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 NYC00LA012Accident · No injuriesLimited investigationFinal reportAmerican Champion 8GCBC · Whiting, VTThe pilot's inadequate preflight passenger briefing, which resulted in control interference.NTSB CHI00LA007Accident · No injuriesLimited investigationFinal reportCessna 150M · Wheeling, ILaircraft control not maintained by the pilot. A factor to the accident was the windshear.NTSB CHI00FA006Accident · Serious injuriesField investigationFinal reportDassault DA-900B · Holland, MIThe copilot's improper use of the autopilot system while leveling the flight from descent, resulting in an inadvertent pilot-induced pitch oscillation of the airplane. A factor was the flight attendant not wearing a seat belt at the time of the occurrence.NTSB LAX00TA006Accident · No injuriesFinal reportMcDonnell Douglas 369E · Moreno Valley, CAThe failure of the pilot to maintain sufficient forward airspeed to preclude an inadvertent encounter with loss of tail rotor effectiveness, which resulted in a loss of yaw control. The pilot's failure to initiate timely remedial action is a factor.NTSB FTW00LA008Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Bay City, TXThe pilot's inadvertent stall. A factor was the pilot's encounter with the airplane's wake turbulence.NTSB LAX00LA003Accident · Serious injuriesLimited investigationFinal reportGiles G-750 · Salinas, CAthe pilot's failure to maintain an adequate airspeed while maneuvering, which led to a stall/mush condition.NTSB FTW00FA001Accident · 2 fatalField investigationFinal reportCessna P210N · Spicewood, TXThe pilot's delayed application of full throttle during a go-around, which resulted in a slow airspeed and inadvertent stall/spin. A factor was the pilot's habit of only applying partial power during takeoff.NTSB CHI99LA349Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Detroit, MIthe pilot's failure to maintain control of the airplane which resulted in the inadvertent spin. A factor was the pilot snagged the banner pole.NTSB CHI99LA353Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Gran Marais, MNthe downwind turn, stall, mush, due to the pilot's decision to turn and failure to maintain flying speed.NTSB ATL99FA135Accident · 2 fatalField investigationFinal reportNorth American T-6-SNJ-5 · Nashville, TNThe pilot's failure to maintain flying speed which resulted in a stall and the loss of control. A factor was pilot impairment due to the use of drugs.NTSB DEN99LA169Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164A · Animas, NMA inadvertent stall during initial climb following takeoff. Factor were: high gross weight, high density altitude, inadequate preflight planning and preparation, and soft terrain.NTSB CHI99FA346Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Fort Scott, KSthe failure of the pilot to maintain control of the aircraft. Factors were the pilot's lack of total experience, his lack of familiarity with the airplane, and the stall/spin encountered.NTSB CHI99LA344Accident · 1 fatalLimited investigationFinal reportBellanca 8KCAB · Atlanta, KSthe pilots failure to maintain control of the aircraft. Factors were the aerobatic maneuvers performed by the pilot and the low altitude.NTSB SEA99LA166Accident · 1 fatalLimited investigationFinal reportPitts 11 · Iona, IDThe pilot-in-command's delayed recovery from a snap roll. A contributing factor was the low altitude at which the maneuver was initiated.NTSB LAX99LA313Accident · No injuriesLimited investigationFinal reportCessna 172N · Merced, CAThe pilot's premature retraction of the flaps during an attempted go-around with insufficient airspeed, which led to an inadvertent stall/mush condition.NTSB CHI99FA342Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Warrensburg, ILAircraft control not being maintained by the private pilot candidate and the inadequate supervision by the FAA Designated Examiner. Factors relating to the accident were the inadvertent spin, the unsuccessful remedial action attempted by the flightcrew, and…NTSB CHI99FA343Accident · 1 fatalField investigationFinal reportPiper J-3 · Brookville, OHthe stall/spin encountered by the pilot. A factor was the intentional slow flight.NTSB CHI99FA341Accident · 3 fatalField investigationFinal reportCessna 172H · Plattsburg, MOthe pilot's failure to maintain airspeed during the initial climb. A factor relating to this accident was the inadvertent stall/spin.NTSB LAX99LA303Accident · 1 fatalLimited investigationFinal reportNye KR-2 · Mariposa, CAThe pilot's failure to maintain an adequate airspeed margin while performing an intentional steep right bank turning maneuver, which resulted in a stall/mush and descent into terrain.NTSB LAX99LA307Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Azusa, CAthe pilot's delay in recognizing the settling with power condition while performing a pinnacle approach, thus delaying his attempted go-around.NTSB SEA99LA159Accident · 2 fatalLimited investigationFinal reportGentry Series 5 Vixen · Naples, IDThe pilot's failure to maintain adequate airspeed during a turn back toward the departure surface, resulting in a stall.NTSB FTW99FA256Accident · 1 fatalField investigationFinal reportSpagnoletti AIR Command 582 · Conroe, TXThe pilot's failure to maintain aircraft control during the takeoff/initial climb. A factor was the pilot's lack of recent experience in the type of aircraft.NTSB ATL99LA131Accident · Minor injuriesLimited investigationFinal reportHiller UH-12A · Satartia, MSThe pilot's failure to maintain control of the helicopter while on approach which resulted in the uncontrolled collision with the ground. A factor was the pilot's physiological condition.NTSB ANC99LA143Accident · No injuriesLimited investigationFinal reportDiehl Interstate S-4 · Anchorage, AKThe pilot's inadequate planning/decision, and his failure to maintain directional control of the airplane. Factors in the accident were a short runway/lake area for departure, and the pilot's extension of the landing gear steering system (water rudders)…NTSB MIA99FA250Accident · Serious injuriesField investigationFinal reportMbb BO105CBS · Kenansville, FLThe pilots failure to recognize entry into settling with power during approach to land and his failure to take remedial action to escape from settling with power resulting in the helicopter descending and colliding with trees and swampy terrain.NTSB CHI99LA334Accident · Minor injuriesLimited investigationFinal reportBell 206B · Nekoosa, WIthe pilot's inadequate compensation for wind gusts. Factors were the wind gusts and the two vehicles parked nearby.NTSB NYC99FA220Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Westerly, RIThe pilot's loss of control of the airplane during a turn.NTSB ANC99LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Kenai, AKThe pilot's inadvertent stall. A factor was the intentional low altitude maneuvering by the pilot.NTSB SEA99LA155Accident · No injuriesLimited investigationFinal reportSchwarzler Kolb Mark 3 · Independence, ORThe pilot's failure to maintain airspeed while on approach.NTSB DEN99LA159Accident · No injuriesLimited investigationFinal reportCessna 172P · Englewood, COThe pilot's failure to maintain adequate airspeed during the flare for landing/touchdown phase of flight. A factor was a ditch off the side of the runway.NTSB ATL99FA122Accident · 3 fatalField investigationFinal reportMooney M20J · Gainesville, GAThe pilot's failure to maintain flying speed which resulted in a stall and the subsequent collision with terrain.NTSB LAX99FA294Accident · 1 fatalField investigationFinal reportMooney M20D · Bear Valley, CAThe pilot's in-flight loss of control for undetermined reasons.NTSB DEN99FA158Accident · 2 fatalField investigationFinal reportWroblewski RV-4 · Bayfield, COThe pilot's failure to maintain control of the aircraft for undetermined reasons.NTSB SEA99LA151Accident · 1 fatalLimited investigationFinal reportRotordyne 200 · Kent, WAThe owner/builder's failure to properly torque the rotor blade retaining bolts.NTSB NYC99FA216Accident · 1 fatalField investigationFinal reportPiper PA-34-200 · Plymouth, MAThe flight instructor's inadequate remedial action, and the pilot-under-instruction's panic and subsequent interference with the flight controls.NTSB IAD99LA061Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-19 · Bedminster, NJthe pilot's medical incapacitation after suffering a massive stroke.NTSB ANC99FA128Accident · 2 fatalField investigationFinal reportCessna 170B · Cooper Landing, AKThe pilot's inadvertent stall.NTSB CHI99LA313Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Pawnee City, NEThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB CHI99FA311Accident · 1 fatalField investigationFinal reportWalker Breezy · Janesville, WIthe inadvertent stall. A factor relating to this accident was the pilot's excessive climb rate.NTSB MIA99LA237Accident · No injuriesLimited investigationFinal reportDinkel-Brook SEA REY · Orlando, FLthe pilot's failure to maintain control of the airplane resulting in an inadvertent stall at too low an altitude to recover.NTSB CHI99LA309Accident · 1 fatalLimited investigationFinal reportPinick Horizon 2 · Grain Valley, MOThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Contributing to the accident was the pilot's lack of experience in this type of airplane.NTSB LAX99LA282Accident · No injuriesLimited investigationFinal reportAerospatiale AS350BA · Kahului, HIThe pilot's initial misjudgment of the wind speed and his decision to continue a downwind landing approach when his speed and altitude profile was inadequate, and his failure to maintain main rotor rpm, resulting in settling with power and a hard landing.NTSB SEA99FA146Accident · 2 fatalField investigationFinal reportRepublic RC-3 · Chimacum, WAThe inadequate visual lookout by both the pilot-in-command and second pilot, and the pilot-in-command's failure to maintain sufficient flying speed to prevent a stall condition. Contributing factors were the transmission lines, gusty wind conditions, and the…NTSB NYC99LA208Accident · 2 fatalLimited investigationFinal reportKlotz Kolb Mark III · Scott, OHThe pilot's failure to maintain airspeed, which resulted in a stall, after he experienced a loss of lift due to an improperly installed gap seal.NTSB MIA99LA231Accident · Serious injuriesLimited investigationFinal reportAlson g. Siler CH-701 · Mount Pleasant, NCThe failure of the pilot to apply sufficient right rudder input during the go-around following a bounced landing and his failure to maintain runway alignment resulting in the in-flight collision with trees 100-150 yards to the left of the runway.NTSB LAX99FA275Accident · 2 fatalField investigationFinal reportMooney M20E · Las Vegas, NVThe pilot's steep turn at low altitude that resulted in an accelerated stall while in the landing configuration, leading to a loss of control and subsequent ground impact.NTSB FTW99LA224Accident · No injuriesLimited investigationFinal reportBell 47G2 · Ardmore, OKThe pilot's failure to maintain rotor rpm which resulted in a hard landing. A factor was the high density altitude.NTSB CHI99LA300Accident · No injuriesLimited investigationFinal reportMaule MXT7-180A · Lapointe, WIthe pilot not maintaining control of the airplane during a crosswind landing. A factor in this accident was inadequate remedial action by the pilot.NTSB CHI99LA299Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Lambertville, MIthe inadequate aircraft preflight by the pilot and the pilot's failure to remove the aileron gust lock before flight. Factors to the accident were the soft terrain adjacent to the runway and the collapse of the nose gear.NTSB CHI99LA295Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Eagle River, WIthe pilot's inadequate compensation for the crosswind conditions and the subsequent failure to maintain directional control of the airplane. Factors associated with the accident were the gusty, crosswind conditions, and the rough/uneven terrain encountered.