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.

NTSB WPR23FA286Accident · 1 fatalClass 3 · FieldFinal reportRisen 915 iS · Glendive, MTThe pilot’s failure to maintain airspeed, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall/spin.Jul 28, 2023 · N2442 · DestroyedNTSB ERA23FA313Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28R · Churchville, MDThe pilot’s exceedance of the airplane’s critical angle of attack during initial climb, which resulted in an aerodynamic stall/spin and loss of control that the pilot did not recover from.Jul 25, 2023 · N34PT · Substantial damageNTSB CEN23FA315Accident · 1 fatalClass 3 · FieldFinal reportCessna 150 · Houston, TXThe student pilot’s loss of airplane control in dark night conditions.Jul 23, 2023 · N17043 · Substantial damageNTSB GAA23WA209Accident · 1 fatalClass 5 · ForeignExtra 300 · Selänpää, FinlandJul 16, 2023 · OH-ESS · DestroyedNTSB CEN23FA304Accident · 2 fatalClass 3 · FieldFinal reportPiper PA28 · Osage Beach, MOThe pilot’s failure to properly set the stabilator trim before takeoff, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall during takeoff.Jul 13, 2023 · N8225N · Substantial damageNTSB CEN23FA284Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-30 · Sherman, TXThe pilot’s failure to maintain control during a forced landing following a loss of engine power. Contributing was the pilot’s failure to feather the left propeller following the loss of engine power.Jul 8, 2023 · N4743M · Substantial damageNTSB CEN23FA283Accident · 2 fatalClass 3 · FieldFinal reportBeech A36 · Rayville, LAThe pilot’s visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control during the approach to the destination airport and subsequent impact with terrain.Jul 7, 2023 · N15RP · DestroyedNTSB WPR23FA256Accident · 1 fatalClass 3 · FieldFinal reportCessna 182N · St Maries, IDThe total loss of engine power due to the failure of the No. 3 exhaust valve for reasons that could not be determined. Contributing to the accident was the pilot’s failure to maintain control of the airplane after the loss of engine power.Jul 6, 2023 · N703Z · Substantial damageNTSB CEN23FA285Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-60-601P · Burlington, COThe pilot’s visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control in flight and subsequent impact with terrain.Jul 6, 2023 · N100PB · DestroyedNTSB CEN23FA248Accident · 2 fatalClass 3 · FieldFinal reportAeronca 7CCM · Duluth, MNThe pilot’s exceedance of the airplane’s critical angle of attack and failure to maintain adequate airspeed, which resulted in an aerodynamic stall and loss of control.Jun 21, 2023 · N308ED · Substantial damageNTSB ERA23FA270Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-30 · Ebensburg, PAThe pilot’s spatial disorientation and subsequent loss of airplane control, which resulted in an uncontrolled descent and collision with terrain.Jun 17, 2023 · N7628Y · DestroyedNTSB CEN23FA239Accident · 2 fatalClass 3 · FieldFinal reportMooney M20R · Watertown, WIThe pilot’s loss of control due to spatial disorientation while operating in instrument meteorological conditions. Contributing to the accident was the pilot’s impairment from the prohibited substance; however, the extent of impairment could not be determined.Jun 14, 2023 · N1025C · DestroyedNTSB ERA23FA266Accident · 1 fatalClass 3 · FieldFinal reportWonder Michael S Harmon Rocket · Porter, NYThe pilot’s failure to maintain control of the airplane while initiating a low-altitude aerobatic maneuver, which resulted in impact with trees and terrain. Contributing to the accident was the pilot’s high-risk behavior.Jun 11, 2023 · N85TP · Substantial damageNTSB GAA23WA165Accident · 1 fatalClass 4 · ForeignPiper PA-32R-301 · Stella Maris, BahamasJun 9, 2023 · N9253M · DestroyedNTSB WPR23FA219Accident · 2 fatalClass 3 · FieldFinal reportSteen Skybolt · Rio Vista, CAThe pilots’ exceedance of the airplane's critical angle of attack while maneuvering to land, which resulted in an aerodynamic stall and subsequent loss of control.Jun 8, 2023 · N202GM · Substantial damageNTSB ERA23FA258Accident · 2 fatalClass 3 · FieldFinal reportCirrus SR22 · Jamestown, NYThe pilots’ failure to maintain airplane control following an anomalous engine indication during the initial climb, which resulted in a loss of control and parachute deployment at an altitude too low for the system to operate effectively. Contributing to the…Jun 6, 2023 · C-GNMT · DestroyedNTSB WPR23FA208Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-31-325 · Tupelo, MSThe pilot's exceedance of the airplane's critical angle of attack while maneuvering after takeoff for reasons that could not be determined, which resulted in an aerodynamic stall and subsequent loss of control.Jun 3, 2023 · N4077W · DestroyedNTSB CEN23FA220Accident · 1 fatalClass 3 · FieldFinal reportVans RV7 · Gibbon, NEThe pilot’s improper decision to fly the airplane into known adverse weather and icing conditions which resulted in a loss of control.Jun 2, 2023 · N977RV · DestroyedNTSB GAA23WA158Accident · 2 fatalClass 5 · ForeignCessna 172 · Monagas, VenezuelaMay 27, 2023 · YV179E · DestroyedNTSB ERA23LA240Accident · 1 fatalClass 3 · LimitedFinal reportCessna R182 · Macon, NCThe pilot’s failure to properly set the elevator trim before takeoff, which resulted in a loss of control during takeoff.May 21, 2023 · N182LG · DestroyedNTSB ERA23FA239Accident · 1 fatalClass 3 · FieldFinal reportCommander 114TC · Palm City, FLA loss of engine power for undetermined reasons, and the pilot’s subsequent loss of control, which resulted in impact with terrain.May 21, 2023 · N6042E · DestroyedNTSB ERA23FA234Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-25-235 · Hollywood, FLThe pilot’s exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and loss of aircraft control.May 17, 2023 · N430AB · DestroyedNTSB CEN23FA190Accident · 1 fatalClass 3 · FieldFinal reportBeech E-90 · Winslow, ARThe pilot’s poor preflight decision to depart into known instrument meteorological conditions (IMC) without a functional autopilot system, which resulted in spatial disorientation and his failure to maintain aircraft control while flying in IMC during the…May 17, 2023 · N522MJ · DestroyedNTSB WPR23FA188Accident · 2 fatalClass 3 · FieldFinal reportCessna T182T · Albany, WYThe pilot’s decision to conduct flight into an area of icing in an airplane that was prohibited from such conditions, which resulted in exceedance of the airplane’s critical angle of attack, an aerodynamic stall/spin, and the pilot’s spatial disorientation…May 14, 2023 · N665B · DestroyedNTSB WPR23FA185Accident · 3 fatalClass 3 · FieldFinal reportGates Lear Jet 36A · San Clemente Island, CAThe pilots’ loss of airplane control following a catastrophic fire that started on the left side of the aft equipment bay (tail cone). The fire likely initiated from a leak from the left fuel motive flow line due to a b-nut that loosened for reasons that…May 10, 2023 · N56PA · DestroyedNTSB CEN23FA174Accident · 4 fatalClass 3 · FieldFinal reportPool Cessna R172 · Victor, COThe pilot’s failure to follow established mountain flying guidance, which resulted in a loss of control and impact with trees and mountainous terrain. Contributing to the accident was the airplane’s reduced climb performance at the elevated density altitude…May 6, 2023 · N15188 · DestroyedNTSB CEN23FA173Accident · 1 fatalClass 3 · FieldFinal reportCessna 310D · Ennis, TXThe partial loss of right engine power due to reduced fuel flow as a result of the contamination of the fuel screen.May 6, 2023 · N6798T · DestroyedNTSB CEN23FA167Accident · 1 fatalClass 3 · FieldFinal reportTitan Tornado · Lewisville, ARThe non-certificated pilot’s failure to maintain airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and loss of control at an altitude too low to recover.Apr 30, 2023 · N31311 · DestroyedNTSB ERA23FA209Accident · 2 fatalClass 3 · FieldFinal reportCessna 177B · Watkinsville, GAThe pilot’s spatial disorientation and subsequent loss of airplane control, which resulted in an in-flight overload separation of the right wing during the uncontrolled descent.Apr 26, 2023 · N123DS · DestroyedNTSB GAA23WA129Accident · 1 fatalClass 5 · ForeignLancair 360 · Taurages, LithuaniaApr 21, 2023 · LY-BRS · Substantial damageNTSB ERA23FA200Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · London, OHThe flight instructor’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at an altitude too low for recovery.Apr 18, 2023 · N734GB · Substantial damageNTSB ERA23FA194Accident · 1 fatalClass 3 · FieldFinal reportHolland Travis E Velocity · Andrews, NCThe pilot’s failure to engage the turbocharger for takeoff and his improper decision to continue the takeoff with partial power, rather than reject the takeoff.Apr 15, 2023 · N2357 · DestroyedNTSB GAA23WA125Accident · 1 fatalClass 5 · ForeignEmbraer EMB203 · Tapurah, BrazilApr 14, 2023 · PT-BYA · Substantial damageNTSB ERA23FA182Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Jesup, GAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in a loss of control while maneuvering for a visual landing in low ceiling and low visibility conditions. Contributing to the…Apr 6, 2023 · N911TK · Substantial damageNTSB ERA23FA181Accident · 4 fatalClass 3 · FieldFinal reportPiper PA32R · Venice, FLThe pilot’s decision to initiate a visual flight rules flight into dark night conditions, which resulted in spatial disorientation during the initial climb and subsequent steep banking descent into water.Apr 6, 2023 · N635BD · DestroyedNTSB WPR23FA141Accident · 2 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Oxbow, ORThe pilot’s continued visual flight into instrument meteorological conditions, resulting in airframe ice accretion and a subsequent loss of airplane control.Apr 2, 2023 · N424SW · DestroyedNTSB ERA23FA175Accident · 2 fatalClass 3 · FieldFinal reportAirbus Helicopters EC 130 T2 · Chelsea, ALThe pilot’s delayed corrective inputs while maneuvering, which resulted in a loss of control. Contributing to the accident was the pilot’s use of multiple sedating medications.Apr 2, 2023 · N231SH · Substantial damageNTSB WPR23FA138Accident · 1 fatalClass 3 · FieldFinal reportAerotrike Cobra · Santa Teresa, NMThe pilot’s exceedance of the aircraft’s critical angle of attack, which resulted in an aerodynamic stall.Apr 1, 2023 · UNREG · DestroyedNTSB CEN23FA142Accident · 2 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 II · Port Allen, LAThe pilot’s decision to continue the visual flight rules flight into deteriorating weather conditions, which resulted in spatial disorientation and the loss of aircraft control.Mar 26, 2023 · N441PD · DestroyedNTSB ERA23FA164Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-161 · Johns Island, SCThe pilot’s decision to continue flight under visual flight rules into instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control. Contributing to the accident was the pilot’s degraded judgement and…Mar 25, 2023 · N21480 · Substantial damageNTSB WPR23FA137Accident · 1 fatalClass 3 · FieldFinal reportCessna 182S · Alcova, WYThe airplane’s encounter with low level wind shear associated with moderate turbulence, which resulted in a loss of airplane control.Mar 21, 2023 · N314FR · Substantial damageNTSB GAA23WA104Accident · 4 fatalClass 4 · ForeignRobinson R44 · Sao Paulo, BrazilMar 17, 2023 · PR-PGC · Substantial damageNTSB CEN23FA139Accident · 1 fatalClass 3 · FieldFinal reportBeech 58P · Lubbock, TXThe pilot’s failure to ensure a proper fuel selector position before takeoff, which resulted in a loss of left engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to maintain airplane control after the loss of left engine…Mar 17, 2023 · N2061K · DestroyedNTSB CEN23FA125Accident · 2 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 · Port O'Connor, TXThe pilot’s initiation of the visual flight into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of helicopter control. Contributing to the accident was the pilot’s flicker vertigo during the flight.Mar 7, 2023 · N494SH · DestroyedNTSB ERA23FA138Accident · 2 fatalClass 3 · FieldFinal reportDiamond Aircraft Ind DA 40 · West Palm Beach, FLThe pilots’ exceedance of the airplane’s critical angle of attack following a go-around/low pass over the runway, which resulted in a loss of control and impact with terrain.Mar 6, 2023 · N804ER · Substantial damageNTSB GAA23WA096Accident · 1 fatalClass 5 · ForeignPitts S1S · Trenque Lauquen, ArgentinaMar 4, 2023 · LX-X768 · DestroyedNTSB ERA23LA135Accident · 1 fatalClass 2 · LimitedFinal reportBombardier BD-100-1A10 · Windsor Locks, CTThe flight crew’s failure to remove the right side pitot probe cover before flight, their decision to depart with a No-Go advisory message following an aborted takeoff, and their selection of the incorrect non-normal checklist in flight, which resulted in an…Mar 3, 2023 · N300ER · Minor damageNTSB WPR23MA113Accident · 5 fatalClass 2 · MajorFinal reportPilatus PC-12/45 · Stagecoach, NVThe pilot’s loss of control due to spatial disorientation while operating in night instrument meteorological conditions, which resulted in an in-flight breakup. Contributing to the accident was the disengagement of the autopilot for undetermined reasons, as…Feb 25, 2023 · N273SM · Substantial damageNTSB CEN23FA113Accident · 5 fatalClass 3 · FieldFinal reportBeech B200 · Little Rock, ARThe loss of control during initial climb for undetermined reasons. Contributing to the accident were the sudden wind shifts during the initial climb.Feb 22, 2023 · N55PC · DestroyedNTSB GAA23WA119Accident · 2 fatalClass 5 · ForeignRobinson R44 · Checkhov, RussiaFeb 17, 2023 · RA-04340 · Destroyed