Fatal NTSB investigations
2,418 cases where the sequence of events included 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 WPR23LA112Accident · 1 fatalClass 3 · LimitedFinal reportStar Lite SL1 · Corning, CAThe student pilot’s loss of airplane control during an intentional aerobatic maneuver, which resulted in an inflight separation of the left wing and subsequent impact with the terrain.NTSB GAA23WA071Accident · 3 fatalClass 5 · ForeignCessna 172H · San Francisco, GuatemalaNTSB CEN23FA095Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Hooker, OKThe pilot’s decision to depart and continue the visual flight rules flight into night instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control.NTSB WPR23FA092Accident · 1 fatalClass 3 · FieldFinal reportCessna 414 · Modesto, CAThe pilot’s exceedance of the airplane’s critical angle of attack and failure to maintain proper airspeed during a turn to final, resulting in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot’s distraction…NTSB CEN23FA084Accident · 4 fatalClass 3 · FieldFinal reportPiper PA46 · Yoakum, TXThe pilot’s spatial disorientation during a missed approach in instrument meteorological conditions, which led to an exceedance of the airplane’s critical angle of attack and a subsequent aerodynamic stall.NTSB ERA23FA109Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-180 · Dawsonville, GAThe pilot’s decision to initiate a visual flight rules flight into night instrument meteorological conditions, resulting in a loss of control in-flight due to spatial disorientation. Contributing to the accident was the pilot’s lack of qualifications and…NTSB CEN23FA077Accident · 2 fatalClass 3 · FieldFinal reportCessna 150H · Auburn, NEThe flight instructor’s failure to maintain control after a loss of engine power due to carburetor icing while maneuvering for forced landing in dark night visual meteorological conditions.NTSB ERA23FA103Accident · 2 fatalClass 3 · FieldFinal reportPiper PA28 · Suffolk, VAThe pilot’s decision to fly the airplane without confirming it had been released from maintenance, which resulted in a partial loss of engine power due to loose magnetos. Contributing to the outcome was the pilot’s failure to maintain adequate airspeed and…NTSB WPR23FA083Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-34-220T · New Harmony, UTThe pilot’s decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in a loss of airplane control due to spatial disorientation.NTSB WPR23FA080Accident · 1 fatalClass 3 · FieldFinal reportEmbraer Executive EMB-505 · Provo, UTThe pilot’s failure to deice the airplane before takeoff in weather conditions conducive to ice accumulation, which resulted in an ice-contaminated wing and subsequent stall during takeoff.NTSB GAA23WA048Accident · 2 fatalClass 5 · ForeignChampion 7GCBC · Prijedori, Bosnia & HerzegovinaNTSB GAA23WA046Accident · 1 fatalClass 5 · ForeignAir Tractor AT502 · Brasnorte, BrazilNTSB ANC23FA008Accident · 3 fatalClass 3 · FieldFinal reportRaytheon C90A · Kaupo, HIGuardian Flight’s inadequate pilot training and performance tracking, which failed to identify and correct the pilot’s consistent lack of skill, and which resulted in the pilot’s inability to maintain his position inflight using secondary instruments to…NTSB GAA23WA042Accident · 1 fatalClass 5 · ForeignPiper PA 46-350P · Happy Valley-Goose Bay, CanadaNTSB GAA22WA311Accident · 1 fatalClass 5 · ForeignRobinson Helicopter R44 II · Kildare, IrelandNTSB CEN23FA060Accident · 3 fatalClass 3 · FieldFinal reportBeech F33A · Yukon, OKThe pilot’s loss of airplane control for reasons that could not be determined.NTSB CEN23FA057Accident · 2 fatalClass 3 · FieldFinal reportCessna 210-5(205) · Cleburne, TXAn in-flight loss of control as a result of spatial disorientation in night instrument meteorological conditions.NTSB ERA23FA079Accident · 3 fatalClass 3 · FieldFinal reportPiper PA28 · Venice, FLThe pilot’s spatial disorientation during takeoff in dark night visual meteorological conditions, which resulted in his failure to maintain a positive rate of climb and a subsequent descent into the water.NTSB WPR23FA047Accident · 2 fatalClass 3 · FieldFinal reportGreg Hobbs Lightning · Torrance, CAThe failure of the pilot to maintain control of the airplane while performing a slip maneuver on final approach. Contributing was the failure of the pilot to fly a stabilized approach.NTSB CEN23FA050Accident · 2 fatalClass 3 · FieldFinal reportCessna 170 · Gage, OKThe non-certificated pilots’ loss of airplane control, resulting in an impact with terrain during final approach. Contributing to the accident was the airplane owner’s impairment due to his use of ethanol and depressant medications, in combination with his…NTSB GAA23WA029Accident · 8 fatalClass 3 · ForeignPiper PA-31-350 · Medellin, ColombiaNTSB ERA23FA067Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-30 · Winston-Salem, NCContamination and/or misalignment of the regulator section of the right engine’s fuel servo, which resulted in excessive idle fuel flow and a total loss of engine power. Also causal was the pilot's failure to land immediately on the nearest runway at the…NTSB GAA23WA041Accident · 1 fatalClass 5 · ForeignAir Tractor AT502 · Vera, BrazilNTSB CEN23FA031Accident · 2 fatalClass 3 · FieldFinal reportPiper PA46-500TP · Bignell, NEThe pilot’s flight into low instrument flight rules conditions and turbulence, which resulted in spatial disorientation, loss of control, and an impact with terrain. Contributing to the accident was the pilot’s lack of total instrument experience.NTSB WPR23FA027Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR20 · San Diego, CAThe student pilot’s exceedance of the critical angle of attack during a go-around, resulting in an aerodynamic stall and impact with terrain following a non-stabilized approach to land.NTSB ERA23FA047Accident · 2 fatalClass 3 · FieldFinal reportHawker Beechcraft G58 · Alpharetta, GAThe pilot’s loss of aircraft control for unknown reasons.NTSB ERA23FA045Accident · 2 fatalClass 3 · FieldFinal reportBearhawk Patrol · Hanover Township, PAThe pilot’s decision to unlatch his seatbelt during flight, which allowed him to exit the airplane and impact the tail, resulting in a loss of control and impact with terrain.NTSB ERA23FA046Accident · 1 fatalClass 3 · FieldFinal reportZenith CH750 Cruzer · Southington, OHThe pilot's failure to maintain proper airspeed while maneuvering in the airport traffic pattern and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at an altitude that was too low to recover.NTSB WPR23LA025Accident · 1 fatalClass 3 · LimitedFinal reportAirborne Windsports Edge X · Alturas, CAThe non-certificated pilot’s loss of control for undetermined reasons.NTSB CEN23FA016Accident · 1 fatalClass 3 · FieldFinal reportVans RV-12 · Chandler, TXThe loss of control inflight for reasons that could not be determined.NTSB ERA23FA024Accident · 2 fatalClass 3 · FieldFinal reportBeech E-90 · Marietta, OHStructural icing on the tailplane that resulted in a tailplane stall and subsequent loss of control.NTSB ERA23FA008Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Newport News, VAThe flight instructor’s failure to monitor the student pilot on takeoff and her delayed remedial action to stop him from exceeding the airplane’s critical angle of attack, which resulted in a low altitude aerodynamic stall from which she was unable to recover.NTSB ERA23FA001Accident · 3 fatalClass 3 · FieldFinal reportCessna 172S · Hermantown, MNThe pilot’s loss of airplane control due to spatial disorientation during initial climb in dark night and low instrument meteorological conditions, which resulted in a descent into terrain. Contributing to the accident was the pilot’s fatigue due to a long…NTSB ENG23WA017Accident · 3 fatalClass 5 · ForeignAirbus Helicopters MBB BK117 · Tabasco, MexicoNTSB GAA22WA294Accident · 3 fatalClass 5 · ForeignCirrus SR22 · Toluca, MexicoNTSB WPR22FA361Accident · 1 fatalClass 3 · FieldFinal reportGrumman American Avn. AA-5B · Sahuarita, AZThe pilot's loss of control following a separation of the aileron carry-through cable.NTSB CEN22FA433Accident · 1 fatalClass 3 · FieldFinal reportAirgyro AG915 · Yankton, SDA loss of control while an in-flight fire occurred, which resulted in an impact with terrain. Contributing to the accident was the pilot/builder’s improper engine build procedures.NTSB GAA22WA291Accident · 1 fatalClass 5 · ForeignChallenger II · Rideau-Ontario, CanadaNTSB GAA22WA290Accident · 1 fatalClass 5 · ForeignMeriwether Jon Arion Lightning · Kenora, CanadaNTSB GAA22WA285Accident · 1 fatalClass 5 · ForeignAir Tractor AT502 · Chinchilla, AustraliaNTSB ERA22FA426Accident · 2 fatalClass 3 · FieldFinal reportChampion Aeronca 7AC · Bridgeton, NJThe pilot's exceedance of the airplane’s critical angle of attack shortly after takeoff, which resulted in an aerodynamic stall, loss of control, and impact with terrain.NTSB WPR22FA350Accident · 1 fatalClass 3 · FieldFinal reportAerovodochody L-29 Delfin · Reno, NVThe pilot’s in-flight incapacitation due to G-induced loss of consciousness, which resulted in a subsequent impact with terrain.NTSB GAA22WA289Accident · 2 fatalClass 5 · ForeignEvektor EV97 · Sesso, Reggio Emilia, ItalyNTSB ERA22FA422Accident · 2 fatalClass 3 · FieldFinal reportWren Ronnie D Titan II · Citra, FLThe pilot’s exceedance of the airplane’s critical angle of attack and failure to maintain airspeed while recovering from an aerobatic maneuver, which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the pilot’s use of…NTSB WPR22FA348Accident · 2 fatalClass 3 · FieldFinal reportTrom Wayne Vans RV6A · Aztec, AZThe total loss of engine power for reasons that could not be determined based on available evidence. Contributing to the accident was the pilot’s decision to turn away from a suitable emergency landing surface, his failure to maintain adequate airspeed as the…NTSB WPR22FA347Accident · 2 fatalClass 3 · FieldFinal reportSkiles Kenneth C RV-6A · Preston, IDThe non-instrument-rated pilot’s continued visual flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation.NTSB CEN22FA416Accident · 1 fatalClass 3 · FieldFinal reportPipistrel Italia S R L Sinus 912 LSA · Waller, TXThe pilot’s failure to maintain aircraft control, which led to an aerodynamic stall at an altitude where recovery was not possible.NTSB ERA22FA405Accident · 1 fatalClass 3 · FieldFinal reportBeech 95-B55 · Hartwell, GAThe pilot’s spatial disorientation and subsequent loss of airplane control following a perceived undetermined problem with the airplane’s gyroscopic instrumentation.NTSB WPR22FA338Accident · 2 fatalClass 3 · FieldFinal reportCzech Sport Piper Sport · Santa Monica, CAThe pilot’s inability to maintain control of the airplane during the landing flare due to the passenger’s excessive control inputs, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall.NTSB CEN22FA406Accident · 2 fatalClass 3 · FieldFinal reportCessna 182 · Cleveland, TNThe pilot’s loss of airplane control while operating in instrument meteorological conditions.