NTSB investigations, 1995
210 cases where the first occurrence was “Loss of control - on ground/water”.
Cases per year
| 1982 | 372 |
|---|---|
| 1983 | 374 |
| 1984 | 329 |
| 1985 | 295 |
| 1986 | 315 |
| 1987 | 331 |
| 1988 | 295 |
| 1989 | 235 |
| 1990 | 278 |
| 1991 | 244 |
| 1992 | 217 |
| 1993 | 232 |
| 1994 | 213 |
| 1995 | 210 |
| 1996 | 221 |
| 1997 | 219 |
| 1998 | 224 |
| 1999 | 247 |
| 2000 | 229 |
| 2001 | 215 |
| 2002 | 204 |
| 2003 | 240 |
| 2004 | 217 |
| 2005 | 228 |
| 2006 | 213 |
| 2007 | 232 |
Where
Latest cases
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
WHERE year(c.\"eventDate\") = 1995
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260)
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE year(c."eventDate") = 1995 AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB NYC96LA046Accident · No injuriesLimited investigationFinal reportCessna 172N · Wildwood, NJfailure of the student pilot to maintain directional control of the airplane. Factors relating to the accident were: the student's selection of the wrong runway, and the crosswind condition.NTSB CHI96LA062Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Excelsior Sprg, MOthe pilot's selection of the wrong runway for landing and the delayed aborted landing. Factors associated with the accident were the tailwind condition and the pilot's inadequate level-off.NTSB NYC96LA043Accident · No injuriesLimited investigationFinal reportPiper J3F · Westerly, RIthe pilot's inadequate compensation for the wind condition, which subsequently resulted in the aircraft nosing over. The gusty crosswind condition was a related factor.NTSB LAX96LA081Accident · No injuriesLimited investigationFinal reportCessna 150M · Quartzsite, AZthe failure of the pilot to maintain directional control during landing.NTSB NYC96LA042Accident · No injuriesLimited investigationFinal reportCessna 150G · East Hampton, NYfailure of the flight instructor to adequately supervise the dual student pilot and ensure that directional control of the airplane was maintained. The icy runway was a related factor.NTSB DCA96MA029Accident · Serious injuriesClass 1 · MajorFinal reportBoeing 747-136 · Jamaica, NYthe captain's failure to reject the takeoff in a timely manner when excessive nosewheel steering tiller inputs resulted in a loss of directional control on a slippery runway. Inadequate Boeing 747 slippery runway operating procedures developed by Tower Air,…NTSB CHI96LA061Accident · No injuriesLimited investigationFinal reportCessna 180C · Patoka, INthe pilot's failure to maintain control of the airplane during takeoff.NTSB ANC96LA019Accident · No injuriesLimited investigationFinal reportCessna 207A · Newtok, AKThe pilot's inadequate compensation for the gusty crosswind conditions. Factors associated with the accident are the snow covered runway, and gusty crosswinds.NTSB NYC96LA039Accident · No injuriesLimited investigationFinal reportCessna 172N · Sanford, MEthe pilot's failure to adequately compensate for a crosswind during the landing roll, which resulted in a collision with a snowbank. Factors relating to the accident were: ice on the runway and the gusty crosswind condition.NTSB NYC96LA037Accident · No injuriesLimited investigationFinal reportCessna 150M · Moultonboro, NHfailure of the pilot to maintain directional control of the airplane during the landing, which allowed the plane to depart the runway and collide with a snowbank. A factor relating to the accident was: the icy runway condition.NTSB LAX96LA064Accident · No injuriesLimited investigationFinal reportEmroth Emair MA-1B · Pahala, HIthe failure of the pilot to adequately compensate for wind conditions, and to maintain directional control of the aircraft during the landing.NTSB BFO96LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Stanton, KYwas the student pilot's failure to maintain directional control of the aircraft. The student pilot's lack of experience was a related factor.NTSB MIA96LA032Accident · No injuriesLimited investigationFinal reportKoutz Q-200 · Valdosta, GAThe pilot's failure to maintain directional control. The crosswind was a factor.NTSB NYC96LA032Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Lake Placid, NYthe pilot's failure to maintain directional control during the landing, and subsequently the airplane veered off the runway.NTSB LAX96LA051Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA20-A1 · San Carlos, CAthe pilot's improper recovery from a bounced landing and failure to maintain directional control, while landing at night.NTSB FTW96LA049Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Heber Springs, ARFailure of the pilot to maintain directional control of the airplane during transition from landing roll to taxi. A factor relating to the accident was: a soft area in the grass runway.NTSB CHI96LA033Accident · No injuriesLimited investigationFinal reportForney F-1 · Estherville, IAthe pilot's failure to maintain directional control of the airplane during the landing. A factor associated with the accident was the crosswind condition.NTSB LAX96LA043Accident · No injuriesLimited investigationFinal reportCessna 172 · Santa Ana, CAThe pilot's failure to maintain directional control which resulted in an inadvertent ground loop. The pilot's diverted attention while raising the flaps and pushing in the carburetor heat control was a factor in this accident.NTSB MIA96LA017Accident · No injuriesLimited investigationFinal reportBoeing B-17G · Fayetteville, NCthe failure of the airplane's normal brake system due to the open position of the pressure relief valve. Contributing to the accident was the pilot in command's premature engine shutdown resulting in the airplane colliding with the localizer building.NTSB FTW96LA036Accident · No injuriesLimited investigationFinal reportCessna 152 · Marietta, OKthe pilot's failure to maintain directional control. A factor was the wet grass runway.NTSB LAX96LA030Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Davis, CAthe pilot's failure to maintain directional control during the takeoff roll by diverting his attention.NTSB LAX96LA031Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Bullhead City, AZThe failure of the pilot/flight instructor to adequately supervise the student pilot resulting in loss of directional control, and his abrupt overcorrection resulting in a waterloop. A contributing factor was the pilot's limited experience as a flight…NTSB LAX96LA025Accident · No injuriesLimited investigationFinal reportCessna 172 · Livermore, CAthe pilot's failure to maintain directional control during the landing roll. A contributing factor was the rough/uneven terrain.NTSB FTW96LA034Accident · No injuriesLimited investigationFinal reportCessna T210F · Tulsa, OKthe pilot's failure to secure a cellular telephone which jammed the rudder pedals.NTSB CHI96LA024Accident · Minor injuriesLimited investigationFinal reportCessna A185E · Liberal, KSthe pilot's inadequate compensation for wind conditions, which resulted in a loss of directional control and an inadvertent ground swerve.NTSB FTW96TA021Accident · No injuriesFinal reportBeech 95 · Albuquerque, NMThe pilot's improper inflight decision to make a landing on an unlit runway and his failure to maintain directional control of the airplane. Factors were the inoperative runway lights, bright lights from surrounding areas, and the pilot's attention being…NTSB ANC96LA008Accident · No injuriesLimited investigationFinal reportCessna 185 · Yakutat, AKThe pilot's improper planning/decision, which resulted in his failure (or inability) to maintain directional control of the airplane, while attempting to negotiate a bend (dog-leg) in the runway. Factors relating to the accident were: variable/gusty wind…NTSB CHI96LA018Accident · No injuriesLimited investigationFinal reportCessna 180G · Belle Fourche, SDthe pilot's inadequate compensation for the wind conditions and his failure to maintain directional control of the airplane while landing. A factor in the accident was the crosswind conditions.NTSB LAX96LA015Accident · Minor injuriesLimited investigationFinal reportPetrik Questair Venture · Crescent City, CAthe pilot's failure to maintain directional control.NTSB FTW96LA018Accident · No injuriesLimited investigationFinal reportCessna 175 · Batesville, ARthe pilot's failure to maintain control of the airplane during landing.NTSB NYC96LA010Accident · No injuriesLimited investigationFinal reportCessna 140 · Albion, NYthe pilot's inadequate planning/decision and compensation for wind conditions, resulting in the airplane nosing over during the taxi.NTSB CHI96LA009Accident · No injuriesLimited investigationFinal reportCessna 180R · Seattle, WAthe pilot's failure to maintain control of the airplane during the landing roll. A factor in the accident was the gusty wind conditions.NTSB MIA96LA005Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Opa Locka, FLThe pilot's failure to maintain directional control of the airplane on landing resulted in a loss of control, sliding off the runway into a rock collapsing the landing gear.NTSB FTW96LA014Accident · No injuriesLimited investigationFinal reportCessna 172M · Sugar Land, TXthe student pilot's diverted attention and failure to maintain directional control.NTSB SEA96LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Logan, UTThe pilot's failure to maintain directional control. A factor to the accident was inadequate remedial action.NTSB ATL96LA002Accident · No injuriesLimited investigationFinal reportSocata TB-9 · Decatur, ALThe student pilot's failure to maintain directional control during an aborted takeoff attempt. A factor was the stripped throttle knob threads.NTSB LAX95LA347Accident · No injuriesLimited investigationFinal reportCessna 152 · Santa Ana, CAthe second pilot's failure to maintain directional control and the first pilot's improper supervision of the flight.NTSB CHI96LA001Accident · No injuriesLimited investigationFinal reportLuscombe Phantom 1 · Rolla, MOmechanical failure of the left brake.NTSB BFO95LA099Accident · No injuriesLimited investigationFinal reportDeangelo Kitfox Speedster · Youngstown, OHthe pilot's failure to maintain directional control of the airplane during the takeoff roll. A related factor was the pilot's lack of familiarity with the aircraft while carrying a passenger.NTSB MIA95LA235Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Melbourne, FLThe failure of the pilot to maintain directional control during landing. Contributing to the accident was the crosswind.NTSB FTW95LA403Accident · No injuriesLimited investigationFinal reportCessna 195 · Moriarty, NMthe pilot's inadequate compensation for the winds. A factor was the crosswind.NTSB ANC95LA175Accident · No injuriesLimited investigationFinal reportCessna 150 · Coldfoot, AKThe pilot's failure to maintain control of the airplane, while landing.NTSB SEA95LA218Accident · No injuriesLimited investigationFinal reportCessna 180 · Pray, MTThe loss of directional control due to the loss of right tailwheel steering. Factors in the accident were: a left quartering crosswind and the sloped side of the road.NTSB FTW95LA396Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Searcy, ARThe pilot's inadequate compensation for the winds. A factor was the crosswind.NTSB CHI95LA321Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Boyne Falls, MIthe pilot's failure to maintain directional control of the airplane during the landing, which resulted in an inadvertent ground swerve.NTSB ANC95LA165Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe pilot's inadequate compensation for the wind conditions. A factor relating to the accident was: the gusty crosswind condition.NTSB ATL95LA166Accident · No injuriesLimited investigationFinal reportCessna 170 · Hartwell, GAThe pilot's failure to maintain directional control during the takeoff roll and failure to take appropriate remedial action. A factor was trees.NTSB FTW95LA382Accident · No injuriesLimited investigationFinal reportCessna 421B · Albuquerque, NMThe pilot's inadequate compensation for the crosswind condition. A factor was the crosswind.NTSB LAX95LA324Accident · No injuriesLimited investigationFinal reportWelles Kitfox Speedster · San Luis Obispo, CAthe pilot's failure to maintain directional control.NTSB NYC95LA213Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Meriden, CTthe pilot's failure to maintain directional control during the landing roll which resulted in the aircraft veering off the runway, and a subsequent collision with a fence.