Skip to content

NTSB investigations

6,629 cases where the first occurrence was “Loss of control - on ground/water”.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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 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

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 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 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 BFO93LA075Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Falmouth, KYThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent swerve, and his delayed remedial action.May 8, 1993 · N1329E · Substantial damage NTSB CHI93LA159Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Grand Forks, NDThe pilot's improper use of collective in recovering from a loss of control due to ground resonance.May 5, 1993 · N7504D · Substantial damage NTSB FTW93LA147Accident · No injuriesLimited investigationFinal reportRaven S-55A · Bentonville, ARAircraft control was not maintained by the pilot. A factor was unfavorable windsMay 1, 1993 · N6465K · Substantial damage NTSB CHI93LA155Accident · No injuriesLimited investigationFinal reportMaule M5 · Green Bay, WIThe pilot's failure to maintain control of the airplane.Apr 30, 1993 · N5644D · Substantial damage NTSB LAX93LA187Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Las Vegas, NVThe pilot's failure to maintain directional control of the aircraft during the touchdown. Factors in the accident were the pilot's lack of experience and his failure to maintain a balance between the wing fuel tanks.Apr 26, 1993 · N83364 · Substantial damage NTSB LAX93LA192Accident · No injuriesLimited investigationFinal reportCessna 182C · Tucson, AZThe excessive approach speed and failure of the first pilot to flare the airplane properly. A factor was the failure of the second pilot to properly supervise the flight.Apr 25, 1993 · N8813T · Substantial damage NTSB DEN93LA045Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Shreveport, LAThe pilot's inadequate compensation for wind conditions. The gusty crosswind was a factor.Apr 23, 1993 · N3917Z · Substantial damage NTSB ATL93LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Lafayette, GAThe failure of the pilot to maintain control of the aircraft.Apr 22, 1993 · N5334F · Substantial damage NTSB CHI93LA144Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Mineral Point, WIThe pilot in command's failure to maintain directional control of the aircraft.Apr 21, 1993 · N2352R · Substantial damage NTSB LAX93LA214Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Yuma, AZThe pilot's failure to maintain directional control on landing and her failure to maintain aircraft control during the attempted go around. Factors in the accident were: 1) the pilot's low total experience, 2) the fuel imbalance between the wing fuel tanks,…Apr 20, 1993 · N3656R · Substantial damage NTSB NYC93LA084Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Buchanan, VAThe pilot's improper planning/decision, inadequate crew coordination, and failure to maintain directional control. The unfavorable wind and proximity of obstructions were related factors.Apr 17, 1993 · N33929 · Substantial damage NTSB LAX93LA179Accident · No injuriesLimited investigationFinal reportCessna 320 · Mesa, AZthe separation of the steering spring from the steering yoke assembly due to inadequate installation. A factor in the accident was inadequate maintenance on the aircraft.Apr 17, 1993 · N5711X · Substantial damage NTSB CHI93LA141Accident · No injuriesLimited investigationFinal reportBeech V-35B · Bennington, KSThe pilot-in-command's failure to maintain directional control of the aircraft.Apr 17, 1993 · N38076 · Substantial damage NTSB ATL93LA073Accident · No injuriesLimited investigationFinal reportCessna 172 · Greenville, TNThe pilot's improper procedures in that he landed with excessive flap extension, and his inadequate compensation for the gusting crosswind.Apr 15, 1993 · N70397 · Substantial damage NTSB MIA93LA102Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Boca Raton, FLThe failure of the pilot-in-command to maintain directional control while landing with a crosswind.Apr 14, 1993 · N3071N · Substantial damage NTSB DCA93MA040Accident · Serious injuriesClass 1 · MajorFinal reportDouglas DC-10-30 · Dallas/Ft Worth, TXThe national transportation safety board determines that the probable cause of the accident was the failure of the captain to use proper directional control techniques to maintain the airplane on the runway.Apr 14, 1993 · N139AA · Substantial damage NTSB NYC93LA081Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Farmingdale, NYThe pilot's inadequate compensation for wind conditions and failure to maintain control of the airplane. The crosswind was a related factor.Apr 13, 1993 · N440AV · Substantial damage NTSB FTW93LA122Accident · No injuriesLimited investigationFinal reportCessna 152 · Lubbock, TXThe pilot's improper compensation for wind conditions. A factor was the gusty crosswind.Apr 10, 1993 · N5283P · Substantial damage NTSB CHI93LA138Accident · No injuriesLimited investigationFinal reportCessna 172N · Towanda, KSThe pilot failed to adequately compensate for a gusty crosswind condition.Apr 10, 1993 · N6346E · Substantial damage NTSB DEN93LA040Accident · No injuriesLimited investigationFinal reportMaule M-6-235 · Englewood, COThe pilot's improper compensation for wind conditions and his failure to maintain directional control. Factors were: a crosswind and tailwind component.Apr 9, 1993 · N56509 · Substantial damage NTSB LAX93LA168Accident · No injuriesLimited investigationFinal reportCessna 152 · San Carlos, CAThe cfi's inadequate supervision of the flight and delaying the remedial action. The dual student's improper use of the brakes is a factor in this accident.Apr 8, 1993 · N89022 · Substantial damage NTSB FTW93LA119Accident · No injuriesLimited investigationFinal reportVaughan Mustang II · Las Cruces, NMThe aircrafts takeoff performance exceeded and pilot's failure to maintain directional control. A factor was the windApr 8, 1993 · N20JV · Substantial damage NTSB NYC93LA071Accident · No injuriesLimited investigationFinal reportCessna 177B · Brookville, OHThe pilot's failure to maintain directional control. Contributing was the lack of recency of experience.Apr 7, 1993 · N11828 · Substantial damage NTSB NYC93LA070Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Norridgewock, METhe pilot at the controls failed to maintain directional control of the airplane, and the flight instructor provided inadequate supervision. A related factor was the pilot at the controls had no flight experience in the make and model of airplane being flown.Apr 6, 1993 · N8775K · Substantial damage NTSB CHI93LA132Accident · No injuriesLimited investigationFinal reportCessna 152 · Sullivan, INThe student pilot's failure to maintain directional control.Apr 6, 1993 · N89098 · Substantial damage NTSB SEA93LA086Accident · No injuriesLimited investigationFinal reportBoeing D75N1 · Davenport, WAUnsuitable terrain was selected for landing. A factor to the accident was: soft terrain.Apr 1, 1993 · N56426 · Substantial damage NTSB CHI93LA151Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Lapeer, MIThe pilot's failure to maintain directional control during the landing roll.Mar 30, 1993 · N7732K · Substantial damage NTSB SEA93LA081Accident · No injuriesLimited investigationFinal reportCessna U206F · Friday Harbor, WAThe improper use of flight controls by the pilot in command. Factors relating to the accident were the strong, tailwind weather conditions.Mar 22, 1993 · N8768Q · Substantial damage NTSB FTW93LA110Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Abbeville, LAThe pilot's failure to compensate for crosswind conditions and the subsequent loss of directional control. Factors were the gusting crosswinds and the soft wet groundMar 20, 1993 · N1337B · Substantial damage NTSB SEA93LA080Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Hailey, IDThe pilot in command's failure to maintain directional control. A factor contributing to the accident was the snowbank.Mar 19, 1993 · N24WW · Substantial damage NTSB LAX93LA155Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Chandler, AZThe student pilot's failure to maintain directional control of the aircraft and his improper remedial action to correct the situation. A factor in the accident was the student's lack of total experience.Mar 19, 1993 · N89681 · Substantial damage NTSB BFO93LA058Accident · No injuriesLimited investigationFinal reportLearjet 35 · Teterboro, NJImproper planning or decision by the pilot in command (PIC). Factors related to the accident were: darkness, the adverse weather conditions, and the runway/terrain condition.Mar 18, 1993 · N304AF · Substantial damage NTSB CHI93LA113Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Mason, MIThe pilot-in-command's failure to maintain directional control.Mar 17, 1993 · N2440T · Substantial damage NTSB SEA93LA075Accident · No injuriesLimited investigationFinal reportCessna 172M · Logan-Cache, UTThe pilot's failure to maintain directional control, and insufficient remedial action. Factors include a snow bank near the edge of the runway.Mar 13, 1993 · N13008 · Substantial damage NTSB CHI93FA109Accident · No injuriesField investigationFinal reportMcdonnell Douglas DC-9-31 · Saint Louis, MOThe captain's improper use of thrust reversers and excessive use of engine power. Factors which contributed to the accident were: the crosswind and the first officer's failure to raise the flaps.Mar 12, 1993 · N978Z · Substantial damage NTSB FTW93LA101Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Goodwin, ARThe pilot's failure to compensate for the crosswind. A factor was the crosswind.Mar 11, 1993 · N634U · Substantial damage NTSB ANC93LA042Accident · Minor injuriesLimited investigationFinal reportCessna 180J · Anchorage, AKThe failure of the private certificated/dual student pilot to maintain directional control. A factor in the accident was the failure of the flight instructor/pilot in command to take timely remedial action.Mar 9, 1993 · N9977N · Substantial damage NTSB SEA93LA099Accident · No injuriesLimited investigationFinal reportCessna 172K · Ogden, UTThe pilot in command's failure to maintain directional control. Factors contributing to the accident were soft terrain, excessive airspeed, and crosswinds.Mar 8, 1993 · N1628C · Substantial damage NTSB FTW93LA113Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Marshall, ARThe pilots failure to maintain directional control. A factor was the fence post.Mar 8, 1993 · N8696D · Substantial damage NTSB FTW93LA099Accident · No injuriesLimited investigationFinal reportCessna 180J · Albuquerque, NMAircraft control not maintained by the pilot. A factor was vibration in the tailwheel for undetermined reasons.Mar 8, 1993 · N7770K · Substantial damage NTSB LAX93LA142Accident · No injuriesLimited investigationFinal reportChampion 7EC · Riverside, CAThe cfi's inadequate supervision of the flight, the dual student's failure to maintain directional control and improper use of the normal brakes. Contributing to this accident was the dual student's improper use of the rudder.Mar 7, 1993 · N9099B · Substantial damage NTSB CHI93LA104Accident · No injuriesLimited investigationFinal reportCessna 152 · Lambertville, MIThe student pilot's failure to maintain directional control during the takeoff roll.Mar 7, 1993 · N67475 · Substantial damage NTSB SEA93LA074Accident · No injuriesLimited investigationFinal reportCessna 150L · Provo, UTDirectional control was not maintained.Mar 6, 1993 · N150KC · Substantial damage NTSB CHI93LA105Accident · No injuriesLimited investigationFinal reportCessna 172M · Romeo, MIThe pilot's failure to maintain directional control.Mar 6, 1993 · N20043 · Substantial damage NTSB CHI93LA101Accident · No injuriesLimited investigationFinal reportBeech 200 · Chesterfield, MOThe pilot's failure to maintain directional control after encountering whiteout conditions in the landing flare.Mar 3, 1993 · N7257T · Substantial damage NTSB BFO93LA041Accident · No injuriesLimited investigationFinal reportCessna 152 · New Cumberland, PAThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was the tailwind and the student pilot's lack of total experience.Mar 3, 1993 · N4705Q · Substantial damage NTSB CHI93LA108Accident · No injuriesLimited investigationFinal reportCessna 150M · Aurora, MOThe pilot-in-command's failure to maintain directional control.Mar 2, 1993 · N704RS · Substantial damage NTSB CHI93LA102Accident · No injuriesLimited investigationFinal reportCessna 172 · Manistique, MIAn excessive taxi speed.Mar 2, 1993 · N8275L · Substantial damage NTSB DEN93LA029Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Broomfield, CORudder control interference.Mar 1, 1993 · N4908G · Destroyed NTSB SEA93LA068Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Winnett, MTThe student pilot's failure to maintain directional control. Factors contributing to the accident were the snowbank and lack of total experience in type operation.Feb 28, 1993 · N789FG · Substantial damage