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.

NTSB SEA96LA149Accident · No injuriesLimited investigationFinal reportCessna 152 · Salt Lake City, UTthe student pilot's improper recovery from a bounced landing, and his failure to maintain adequate airspeed during go-around. The student pilot's improper level-off was a factor.Jul 10, 1996 · N4897P · Substantial damageNTSB ATL96FA103Accident · 2 fatalField investigationFinal reportGeorge Evenson Cuby · Hawkinsville, GAThe failure of the pilot-in-command to maintain airspeed.Jul 9, 1996 · N1035W · DestroyedNTSB IAD96FA107Accident · 5 fatalField investigationFinal reportBell 206B · Salem, OHThe pilot's impairment of judgment and performance due to alcohol and the pilot's improper handling of the helicopter resulting in a loss of tail rotor effectiveness. A related factor was the pilot's disregard for the aircraft's weight and balance while…Jul 8, 1996 · N49578 · DestroyedNTSB SEA96LA142Accident · No injuriesLimited investigationFinal reportMaule MX-7-180 · Newport, ORthe passenger's inadvertent activation of the aircraft's rudder, which resulted in a loss of directional control and collision with a tree during an attempted go-around (aborted landing).Jul 5, 1996 · N5663U · Substantial damageNTSB NYC96LA142Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Greenwood Lake, NJfailure of the pilot to maintain adequate airspeed, during the approach/go-around, which resulted in an inadvertent stall and collision with the terrain.Jul 5, 1996 · N6137H · Substantial damageNTSB NYC96LA140Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 1-26E · Marston Mills, MAfailure of the pilot to maintain control of the glider while being towed during takeoff, which resulted in a pitch oscillation, failure of the tow cable, loss of airspeed, an inadvertent stall/spin, and an uncontrolled collision with the ground.Jul 5, 1996 · N603MX · DestroyedNTSB FTW96LA313Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Corsicana, TXThe pilot's failure to maintain adequate airspeed. A factor was the high wind.Jul 4, 1996 · N71973 · Substantial damageNTSB NYC96LA139Accident · 1 fatalLimited investigationFinal reportTitan Tornado · Richland, NYfailure of the student pilot to maintain adequate airspeed, during an apparent go-around, which resulted in an inadvertent stall and subsequent collision with the terrain. Factors relating to the accident were: the pilot's lack of certification, and…Jul 2, 1996 · UNREG · DestroyedNTSB FTW96TA289Accident · Minor injuriesFinal reportCessna 182RG · Broomfield, COfailure of the pilot to maintain directional control and runway alignment during a go-around, and the lack of power response from the engine for undetermined reason(s). The sudden wind shift was a related factor.Jul 2, 1996 · N4314R · Substantial damageNTSB NYC96LA135Accident · No injuriesLimited investigationFinal reportBell 206B III · South Carver, MAThe pilot's failure to maintain control of the helicopter during an aerial application maneuver. This put the helicopter in a low slow down wind, high power demand turn, where it encountered a loss of tail rotor effectiveness, and the subsequent collision…Jul 1, 1996 · N444JB · Substantial damageNTSB FTW96LA286Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Almyra, ARThe pilot's failure to maintain aircraft control. A factor was the pilot's excessive use of flaps during the maneuver.Jul 1, 1996 · N7314C · DestroyedNTSB FTW96LA278Accident · Serious injuriesLimited investigationFinal reportRyan PT-22 · Krum, TXthe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A factor was his lack of recent experience in the make and model of airplane.Jun 28, 1996 · N47621 · Substantial damageNTSB CHI96LA224Accident · 1 fatalLimited investigationFinal reportPiper PA-36-375 · Windfall, INfailure of the pilot to maintain adequate airspeed, while maneuvering to avoid an obstruction (transmission line), which resulted in a stall and collision with the terrain. His lack of familiarity with the geographic area was a related factor.Jun 28, 1996 · N2459X · DestroyedNTSB SEA96FA137Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Pray, MTthe pilot's delay in initiating a go-around, and his failure to obtain and/or maintain sufficient airspeed to avoid higher terrain during the go-around, which resulted in a stall and collision with terrain. Factors relating to the accident were: the narrow…Jun 27, 1996 · N7529J · DestroyedNTSB FTW96LA270Accident · Minor injuriesLimited investigationFinal reportAmerican AG5B · Longmont, COAn inadvertent stall spin. Factors were the pilot's intentional maneuver at an altitude insufficient to ensure a safe recovery, and overconfidence in his personal ability.Jun 24, 1996 · N227ER · DestroyedNTSB CHI96LA210Accident · 1 fatalLimited investigationFinal reportFarland Genesis · Le Sueur, MNthe pilot's impairment of judgment and performance due to drugs, and his failure to maintain control of the airplane, which resulted in an uncontrolled descent and collision with terrain. Factors related to the accident were: the pilot's limited aeronautical…Jun 24, 1996 · N9274S · DestroyedNTSB SEA96FA134Accident · 2 fatalField investigationFinal reportCessna 150B · Hailey, IDthe pilot's improper planning/decision, and his failure to maintain adequate airspeed during a climb over rising terrain, which resulted in a stall and collision with terrain. Factors relating to the accident were: failure of the pilot to ensure the airplane…Jun 21, 1996 · N1236Y · DestroyedNTSB IAD96FA100Accident · 1 fatalField investigationFinal reportPiper PA-31-325 · Springboro, OHthe pilot's impairment of judgment and performance due to drugs which led to spatial disorientation and a loss of aircraft control. The weather was a factor.Jun 19, 1996 · N62852 · DestroyedNTSB NYC96FA125Accident · 3 fatalField investigationFinal reportBeech V35 · Williamstown, NJinadequate supervision by the flight instructor (CFI); and failure of the pilot rated (dual) student to maintain control of the airplane during a simulated forced landing after takeoff, which resulted in a stall and collision with the terrain. Factors…Jun 13, 1996 · N2011W · DestroyedNTSB CHI96LA199Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Charlotte, MIthe pilot's inadequate preflight planning and failure to use all the available runway for takeoff. Factors associated with the accident were the wet grass airstrip and the powerlines.Jun 13, 1996 · N16047 · Substantial damageNTSB SEA96LA128Accident · 1 fatalLimited investigationFinal reportBailey Antares MA30 · Woodland, WAfailure of the uncertificated pilot to maintain adequate airspeed during the initial climb after takeoff, which resulted in a stall and collision with the terrain. The pilot's abrupt pull-up was a related factor.Jun 10, 1996 · UNREG · Substantial damageNTSB NYC96FA123Accident · 2 fatalField investigationFinal reportBeech E90 · Woolwich, MEfailure of the pilot to maintain control of the airplane while climbing after takeoff, due to spatial disorientation, which resulted in an uncontrolled descent and subsequent collision with terrain. Factors relating to the accident were: the improper…Jun 10, 1996 · N916PA · DestroyedNTSB FTW96FA243Accident · 1 fatalField investigationFinal reportAeronca 65-CA · Lonoke, ARThe pilot's failure to maintain aircraft control.Jun 10, 1996 · N36513 · Substantial damageNTSB LAX96FA223Accident · 3 fatalField investigationFinal reportCessna 172N · Bermuda Dunes, CAthe pilot's impairment of judgment and performance due to alcohol and drugs (methamphetamine, amphetamine, & marijuana), his excessive maneuvering (pull-up) after making a touch-and-go landing, and his failure to maintain sufficient airspeed, which resulted…Jun 9, 1996 · N734FB · DestroyedNTSB SEA96LA114Accident · Serious injuriesLimited investigationFinal reportCessna T188C · Roundup, MTfailure of the pilot to maintain adequate airspeed, during a turn-around maneuver after a swath run, which resulted in an inadvertent stall.Jun 7, 1996 · N4970J · DestroyedNTSB NYC96LA122Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Danbury, CTthe safety pilot's raising of the flaps, while the airplane was at an inadequate airspeed during the aborted landing, which resulted in a stall, uncontrolled descent, and subsequent collision with parked airplanes.Jun 7, 1996 · N11637 · DestroyedNTSB LAX96FA226Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Goleta, CAfailure of the flying pilot to maintain control of the airplane, due to spatial disorientation, which resulted in an uncontrolled descent and collision with the water. Factors relating to the accident were: the lack of recent instrument experience by the…Jun 7, 1996 · N4303X · DestroyedNTSB FTW96FA239Accident · 2 fatalField investigationFinal reportFredenburg Challenger II · Longview, TXthe pilot-in-command's failure to maintain airspeed. A factor was the pilot's lack of total experience in the make/model.Jun 7, 1996 · N2087P · DestroyedNTSB SEA96LA113Accident · Serious injuriesLimited investigationFinal reportAyres S2R · Aberdeen, IDpilot's improper planning/decision, and subsequent incapacitation, which resulted in a loss of aircraft control and collision with the terrain. Factors relating to the accident were: pilot fatigued from a long-distance drive with minimal rest, physical…Jun 6, 1996 · N5686X · Substantial damageNTSB LAX96LA219Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Paso Robles, CAthe student pilot's loss of control and subsequent dynamic rollover due to his abrupt and excessive use of the collective and anti-torque controls.Jun 5, 1996 · N2311R · Substantial damageNTSB IAD96LA089Accident · No injuriesLimited investigationFinal reportPiper PA60-601P · Willard, OHthe pilot's inability to maintain directional control of the airplane during the landing flare/touchdown.Jun 3, 1996 · N86AT · Substantial damageNTSB CHI96FA184Accident · 4 fatalField investigationFinal reportPiper PA-46-310P · Aitkin, MNthe pilot's continued flight into known adverse weather conditions and the pilot exceeding the design stress limits of the airplane. Factors contributing to this accident were: the thunderstorms, hail, and wind gusts, and the airplane's over maximum gross…Jun 2, 1996 · N9114Q · DestroyedNTSB SEA96LA110Accident · No injuriesLimited investigationFinal reportStelly Kolb Firestar II · Independence, ORfailure of the pilot to maintain adequate airspeed during the initial climb after takeoff, which resulted in an inadvertent stall and collision with the terrain. The aircraft's excessive gross weight was a related factor.Jun 1, 1996 · N2213U · Substantial damageNTSB SEA96LA105Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Puyallup, WAthe pilot's improper recovery from a bounced landing, and failure to maintain runway alignment during a go-around. The pilot's improper flare for landing was a related factor.May 31, 1996 · N72344 · Substantial damageNTSB FTW96LA231Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Bunkie, LAThe pilot's failure to maintain control of the airplane.May 31, 1996 · N188TB · Substantial damageNTSB ATL96LA089Accident · No injuriesLimited investigationFinal reportSchweizer SGS233A · Franklinton, NCthe failure of the instructor pilot to maintain control of the aircraft.May 30, 1996 · N1197S · Substantial damageNTSB FTW96FA230Accident · 5 fatalField investigationFinal reportPiper PA-31T · Malvern, ARThe pilot's failure to maintain control of the airplane after takeoff.May 29, 1996 · N333LM · DestroyedNTSB FTW96FA228Accident · 1 fatalField investigationFinal reportAir Tractor AT-401 · Lake Providence, LAfailure of the pilot to maintain sufficient airspeed, while maneuvering (turning), which resulted in an inadvertent stall and collision with the terrain. The high gusty wind condition was a related factor.May 28, 1996 · N1549D · DestroyedNTSB FTW96LA229Accident · No injuriesLimited investigationFinal reportBell 47J · Lakeway, TXThe pilot's failure to maintain a proper descent rate prior to landing.May 26, 1996 · N8412E · Substantial damageNTSB CHI96FA172Accident · 2 fatalField investigationFinal reportCessna 152 · Mount Pleasant, MIloss of aircraft control by the pilot, due to cardiac arrest (heart attack).May 26, 1996 · N68610 · DestroyedNTSB CHI96LA176Accident · No injuriesLimited investigationFinal reportMerlin GT · Charlotte, MIthe pilot's failure to maintain airspeed. A factor was the pilot's lack of experience in the airplane.May 25, 1996 · N68EV · Substantial damageNTSB NYC96FA113Accident · No injuriesField investigationFinal reportBeech A36 · Meriden, CTthe pilot's improper planning/decision, his failure to use takeoff power, and his premature lift-off of the airplane, which resulted in an inadvertent stall/mush and subsequent collision with terrain. Factors relating to the accident were: the pilot allowing…May 24, 1996 · N59WW · DestroyedNTSB IAD96FA085Accident · Minor injuriesField investigationFinal reportPiper PA-31-310 · Stevensville, MDThe pilot's improper short field takeoff/procedure and selection of the wrong runway for takeoff.May 24, 1996 · N103RW · DestroyedNTSB CHI96FA169Accident · 1 fatalField investigationFinal reportBeech F33A · Saint Clair, MOfailure of the pilot to maintain adequate airspeed, while maneuvering at low altitude, which resulted in a stall and collision with the terrain.May 23, 1996 · N8273G · DestroyedNTSB NYC96LA110Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Monticello, NYthe student pilot's inadequate compensation for wind conditions, and her delay in aborting the landing. The gusty crosswind condition was a related factor.May 20, 1996 · N38890 · DestroyedNTSB MIA96LA143Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Vilarica, GAThe student pilot's failure to maintain airspeed (VSO) during a go-around resulting in an in-flight loss of control (inadvertent stall), and subsequent in-flight collision with terrain. Contributing to the accident was the pilot's improper use of flaps.May 20, 1996 · N2814U · Substantial damageNTSB NYC96LA111Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Bloomingburg, NYThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall spin and collision with trees.May 19, 1996 · N65847 · Minor damageNTSB FTW96LA218Accident · Minor injuriesLimited investigationFinal reportMaule MX-7-160 · Belcher, LAThe pilot's failure to maintain aircraft control in flight. A factor was the gusty wind.May 18, 1996 · N35TX · Substantial damageNTSB CHI96LA165Accident · Serious injuriesLimited investigationFinal reportAS+ AC 4 · Hartford, WIlack of airspeed control by the pilot, while maneuvering.May 18, 1996 · N29HS · Substantial damageNTSB CHI96LA164Accident · No injuriesLimited investigationFinal reportSchlitter Rans S6ES Coyote II · Hays, KSfailure of the pilot to maintain control of the airplane, when it settled back to the runway after lift-off. A factor relating to the accident was: premature raising of the flaps after lift-off.May 18, 1996 · N4307N · Substantial damage