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 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.NTSB ATL96FA103Accident · 2 fatalField investigationFinal reportGeorge Evenson Cuby · Hawkinsville, GAThe failure of the pilot-in-command to maintain airspeed.NTSB 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…NTSB 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).NTSB 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.NTSB 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.NTSB FTW96LA313Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Corsicana, TXThe pilot's failure to maintain adequate airspeed. A factor was the high wind.NTSB 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…NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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…NTSB 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…NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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…NTSB FTW96FA243Accident · 1 fatalField investigationFinal reportAeronca 65-CA · Lonoke, ARThe pilot's failure to maintain aircraft control.NTSB 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…NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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…NTSB 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.NTSB IAD96LA089Accident · No injuriesLimited investigationFinal reportPiper PA60-601P · Willard, OHthe pilot's inability to maintain directional control of the airplane during the landing flare/touchdown.NTSB 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…NTSB 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.NTSB 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.NTSB FTW96LA231Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Bunkie, LAThe pilot's failure to maintain control of the airplane.NTSB ATL96LA089Accident · No injuriesLimited investigationFinal reportSchweizer SGS233A · Franklinton, NCthe failure of the instructor pilot to maintain control of the aircraft.NTSB FTW96FA230Accident · 5 fatalField investigationFinal reportPiper PA-31T · Malvern, ARThe pilot's failure to maintain control of the airplane after takeoff.NTSB 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.NTSB FTW96LA229Accident · No injuriesLimited investigationFinal reportBell 47J · Lakeway, TXThe pilot's failure to maintain a proper descent rate prior to landing.NTSB CHI96FA172Accident · 2 fatalField investigationFinal reportCessna 152 · Mount Pleasant, MIloss of aircraft control by the pilot, due to cardiac arrest (heart attack).NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB CHI96LA165Accident · Serious injuriesLimited investigationFinal reportAS+ AC 4 · Hartford, WIlack of airspeed control by the pilot, while maneuvering.NTSB 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.