NTSB investigations
8,203 cases where the first occurrence was “Loss of control - in flight”.
Cases, newest first
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 c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250) 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" = 250) 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 MIA98FA010Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Knoxville, TNfailure of the pilot to maintain control of the airplane, while climbing after takeoff, which resulted in an uncontrolled descent and impact with the water.NTSB LAX98LA010Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lanai City, HIInterference on the controls by the passenger as the aircraft neared touchdown, and the pilot's failure to adequately brief and supervise the passenger on the use and relinquishing of the flight controls. A factor in the accident was the intentional control…NTSB CHI98LA014Accident · 2 fatalLimited investigationFinal reportCessna 172N · Terre Haute, INThe pilot's failure to maintain adequate airspeed during a go-around attempt which resulted in an inadvertent stall.NTSB NYC98FA009Accident · 4 fatalField investigationFinal reportPiper PA-28R-180 · Morganville, NJThe inadequate maintenance by the flying club and maintenance facility, which resulted in a takeoff with a partially blocked fuel injector nozzle and the failure of the landing gear to retract after takeoff. This resulted in the pilot's diverted attention and…NTSB FTW98LA013Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Folsum, NMthe pilot's failure to maintain aircraft control during takeoff, which resulted in a stall/mush. A related factor was the crosswind condition.NTSB CHI98LA015Accident · No injuriesLimited investigationFinal reportReed-Madsen Taylor Bird · Humboldt, IAthe failure of the pilot-in-command to attain airspeed and maintain control of the aircraft, resulting in a stall/mush.NTSB CHI98LA005Accident · No injuriesLimited investigationFinal reportCessna 172N · Sandwich, ILthe pilot's inability to maintain flying airspeed resulting in an inadvertent stall/mush. A factor contributing to this accident was the wind gust.NTSB NYC98LA002Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Georgetown, DEThe student pilot's improper recovery from the bounced landing and the flight instructor's delayed remedial action.NTSB CHI98LA002Accident · Serious injuriesLimited investigationFinal reportMikowski Challenger II S · Lake City, MIthe improper oil to gas mixture in the fuel during refueling and the pilot did not follow the written instructions from the kit manufacturer. Factors contributing to the accident were the pilot could not maintain directional control and the low altitude.NTSB FTW97LA369Accident · No injuriesLimited investigationFinal reportHughes 369HS · Morgan, UTThe pilot's failure to maintain directional control because he exceeded the helicopter's hover performance. A factor was the high density altitude.NTSB CHI97LA302Accident · Serious injuriesLimited investigationFinal reportRans S-11 Pursuit · Hays, KSfailure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall and collision with the terrain. The pilot's lack of experience in the make and model of airplane was a related factor.NTSB SEA97LA218Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Dixie, IDShifting of a briefcase stored behind the pilot's seat to a position where it obstructed movement of the rudder pedals, resulting in loss of directional control capability. A factor was trees adjacent to the airstrip.NTSB IAD97FA123Accident · 1 fatalField investigationFinal reportFairchild Hiller FH-1100 · Pittsfield, MAThe first pilot's improper procedures for an autorotation, and improper flare which resulted in a hard landing. Also causal was the second pilot's inadequate remedial action.NTSB FTW97LA366Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Huntsville, TXfailure of the student pilot to maintain directional control of the helicopter during a flare to landing. Factors relating to the accident were: the student pilot's misinterpretation of the wind direction, his selection of the wrong runway, and the resultant…NTSB FTW97LA364Accident · Serious injuriesLimited investigationFinal reportBell 206B2 · Anahuac, TXthe pilot's inability to maintain control of the helicopter after encountering a dynamic rollover due to entanglement of the external load cable with the left landing gear skid.NTSB SEA97LA214Accident · No injuriesLimited investigationFinal reportCessna 172RG · Monroe, WAThe failure of the flight instructor to adequately perform remedial action, and her failure to abort the takeoff. Factors contributing to the accident include the premature rotation of the airplane by the dual student, the failure of the dual student to…NTSB NYC97FA185Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Glastenbury, VTthe pilot's improper decision to disregard the weather briefing and continue into adverse weather which resulted in a loss of control. The weather was a factor.NTSB IAD97FA122Accident · 1 fatalField investigationFinal reportCessna 172P · Airville, PAThe student pilot's failure to maintain adequate airspeed which resulted in a stall/mush and subsequent collision with terrain.NTSB LAX97FA328Accident · 4 fatalField investigationFinal reportBeech C23 · Torrance, CAThe failure of the pilot to attain and maintain adequate airspeed during the initial takeoff climb, which resulted in a stall/spin and subsequent collision with a building.NTSB FTW97LA353Accident · 1 fatalLimited investigationFinal reportAerotek Pitts S-2A · San Marcos, TXThe pilot's loss of control while performing aerobatics resulting in an inadvertent stall/spin. A factor was the lack of altitude available for recovery.NTSB FTW97GA350Accident · 2 fatalFinal reportBell OH-58A · Newark, TXThe pilot's failure to maintain adequate rotor rpm which resulted in a loss of aircraft control.NTSB CHI97LA295Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Greenwood, INthe student pilot's failure to maintain adequate airspeed during the go-around, which resulted in an inadvertant stall. A factor related to the accident was the raising of flaps.NTSB FTW97LA351Accident · Serious injuriesLimited investigationFinal reportBrashears MONERAI-S · Artesia, NMthe pilot's improper handling of the aircraft during takeoff, which resulted in an inadvertent stall and collision with the terrain. A factor relating to the accident was: the pilot's lack of recent flight experience in the make and model of aircraft.NTSB FTW97FA348Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Telluride, COfailure of the pilot to maintain adequate airspeed, while climbing after takeoff, which resulted in an inadvertent stall/spin and collision with terrain. Factors relating to the accident included: the pilot allowing the maximum gross weight limit of the…NTSB FTW97LA346Accident · 1 fatalLimited investigationFinal reportReilly Thorp T-18 · Wagoner, OKthe pilot's failure to maintain airspeed.NTSB CHI97FA293Accident · 2 fatalField investigationFinal reportKeaggy-David Skybolt · Adeline, ILThe pilot's failure to maintain aircraft control for undetermined reasons.NTSB CHI97FA290Accident · 3 fatalField investigationFinal reportBeech 76 · West Lafayette, INthe inadvertent stall. A related factor was the instructor pilot's failure to ensure the elevator trim was reset for takeoff.NTSB LAX97LA320Accident · Minor injuriesLimited investigationFinal reportBell 206B · Minden, NVA hard landing due to the failure of the pilot to adequately compensate for the wind direction and velocity on initiating his approach to the landing area, resulting in a loss of tail rotor authority.NTSB FTW97LA339Accident · 1 fatalLimited investigationFinal reportRoddie MINI-500 · Idabel, OKThe loss of control in flight for undetermined reasons. A factor was the pilot's lack of total experience in helicopters.NTSB LAX97LA318Accident · No injuriesLimited investigationFinal reportBeech A23A · Tucson, AZthe student pilot's improper recovery from a bounced landing, and failure to maintain adequate airspeed during an attempted go-around, which resulted in a stall and impact with the terrain (runway).NTSB SEA97LA204Accident · 2 fatalLimited investigationFinal reportPiper J-3 · Jordan, MTThe pilot's inadequate remedial action during an inadvertent stall/spin entry. Factors include buzzing, a rapid pull-up, and failure to maintain proper airspeed (Vs).NTSB IAD97LA118Accident · Serious injuriesLimited investigationFinal reportReynolds MARSKE-MONARCH 1997 · Sutton, WVThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall/spin. A related factors was the pilot lack of familiarity with the airplane.NTSB FTW97LA341Accident · Serious injuriesLimited investigationFinal reportBurgess Skyhopper · Jonesboro, ARThe pilot's failure to obtain/maintain the aircraft's airspeed. Factors were the high density altitude and the lack of suitable terrain for the forced landing.NTSB CHI97LA287Accident · Serious injuriesLimited investigationFinal reportHiggens Rans S-12 XL · Tuscola, ILthe pilot's failure to maintain adequate airspeed, while maneuvering, which resulted in an inadvertent stall.NTSB SEA97FA201Accident · 5 fatalField investigationFinal reportCessna 182C · Bremerton, WAThe pilot's failure to maintain adequate airspeed in a climbing turn at low altitude, resulting in a stall and impact with terrain. A factor was the pilot exceeding the aircraft's maximum takeoff gross weight limitation.NTSB FTW97LA335Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Marksville, LAThe pilot's inadvertent stall during a turn to reverse direction during an aerial application flight. A factor was the pilot's chronic fatigue as result of cumulative long workdays.NTSB CHI97LA280Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Monona, IAthe pilot's improper in-flight planning/decision, and subsequently, his not being able to attain remedial action to avoid impact with the terrain. A related factor was the downdraft.NTSB SEA97LA200Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Elk City, IDA horse and children wandered onto the airstrip.NTSB LAX97LA308Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Gerlach, NVThe pilot's failure to maintain an adequate airspeed while attempting a right slip, which resulted in an inadvertent stall.NTSB CHI97LA277Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Council Bluffs, IAinadequate supervision by the designated examiner by failing to ensure a timely autorotation recovery was initiated. A related factor was: the student pilot allowed the rotor rpm to diminish after the examiner simulated a loss of engine power.NTSB ATL97LA128Accident · No injuriesLimited investigationFinal reportCessna 172M · Lawrenceville, GAThe student pilot's improper go-around technique that resulted in an inadvertent stall. A factor was a premature flare for landing.NTSB SEA97LA199Accident · No injuriesLimited investigationFinal reportComeaux Kitfox 1 · Bend, ORThe private pilot-in-command's failure to ensure that directional control was maintained. A related factor was the private pilot's lack of total flight experience.NTSB NYC97LA174Accident · Minor injuriesLimited investigationFinal reportHiller UH-12B · Slatington, PAThe pilot's failure to maintain control of the helicopter.NTSB NYC97FA172Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Baptistown, NJfailure of the pilot to maintain control of the airplane for undetermined reason(s), while operating it at low altitude.NTSB IAD97LA114Accident · Minor injuriesLimited investigationFinal reportSchleicher ASW19-B · Troy, PAPilot failed to maintain airspeed which resulted in an inadvertent stall.NTSB NYC97LA171Accident · 1 fatalLimited investigationFinal reportLorello Genesis · Columbia Statn, OHThe pilot's failure to maintain airspeed.NTSB ANC97LA135Accident · Serious injuriesLimited investigationFinal reportCessna 185E · Igiugig, AKfailure of the pilot to maintain adequate airspeed, during a maneuvering turn at low altitude, which resulted in an accelerated stall and subsequent collision with the terrain. A factor relating to the accident was: the lack of altitude to recover from the…NTSB NYC97FA170Accident · 1 fatalField investigationFinal reportCessna 337B · Warren Township, NJthe pilot's loss of control in flight for undetermined reasons and the subsequent collision with terrain.NTSB IAD97FA112Accident · 3 fatalField investigationFinal reportClassic YMF-5 · Ocean City, MDThe pilot performed an aerobatic maneuver at a low altitude, which resulted in an inadvertent stall/spin.NTSB CHI97LA269Accident · No injuriesLimited investigationFinal reportCessna 177 · Maple Lake, MNthe pilot failure to maintain control of the airplane while landing and his improper recovery from the bounced landing. Factors associated with the accident were the night conditions and the pilot lack of recent experience with night operations.