NTSB investigations
3,842 cases where the defining event 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '240') 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '240') 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 DEN08LA066Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Las Vegas, NMAn inadvertent settling with power, and the instructor's failure to maintain control of the helicopter, resulting in a hard landing. Contributing to the accident was the downdraft.NTSB NYC08CA141Accident · No injuriesData collectionFinal reportPiper PA-25-260 · Opa Locka, FLThe entanglement of the hook rope with the rudder horn during banner pickup.NTSB NYC08CA140Accident · No injuriesData collectionFinal reportRobinson R44 · Montgomery, NYThe pilot's loss of control during takeoff.NTSB MIA08CA078Accident · Minor injuriesData collectionFinal reportAir Tractor AT-301 · Columbus, MSThe failure of the pilot to maintain airspeed while maneuvering.NTSB ANC08CA043Accident · Minor injuriesData collectionFinal reportStinson 108 · Chugiak, AKThe reversal of the aileron control cables by maintenance personnel, and the pilot's inadequate preflight inspection.NTSB NYC08FA134Accident · 1 fatalField investigationFinal reportRobinson R22 Beta II · Wilmington, NCThe pilot's failure to maintain proper rotor rpm after a partial loss of engine power.NTSB NYC08CA136Accident · Serious injuriesData collectionFinal reportJ&J Ultralights Sea Wing · Live Oak, FLThe student pilot's failure to maintain directional control during a go-around. Contributing to the accident was his habit interference from previously flying conventional airplanes.NTSB DFW08LA081Accident · 1 fatalLimited investigationFinal reportRitter RV-10 · Ledbetter, TXThe pilot's loss of control for undetermined reasons.NTSB SEA08CA088Accident · No injuriesData collectionFinal reportAmerican Champion 7GCAA · Tracy, CAThe flight instructor's inadequate compensation for the tailwind condition and failure to maintain adequate airspeed that led to an inadvertent stall.NTSB MIA08CA073Accident · No injuriesData collectionFinal reportCessna 182 · Fort Lauderdale, FLThe pilot's failure to maintain directional control during recovery from a bounced landing.NTSB MIA08CA072Accident · No injuriesData collectionFinal reportEurocopter France AS350B1 · Linden, NJThe pilot's improper preflight preparation and his failure to maintain control of the helicopter.NTSB DFW08CA075Accident · No injuriesData collectionFinal reportRobinson R-22 · Meraux, LAThe pilot's failure to ensure calculate weight and balance prior to flight. A contributing factor was the prevailing gusty winds.NTSB ANC08LA040Accident · Minor injuriesLimited investigationFinal reportBell 206L · Nikolai, AKThe pilot's inadequate compensation for wind conditions, and an inadvertent loss of tail rotor effectiveness while maneuvering. A factor contributing to the accident was wind gusts.NTSB ANC08LA039Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Nikolai, AKThe flight instructor's inadequate evaluation of the weather conditions. Contributing to the accident was an inadvertent stall/mush.NTSB LAX08CA069Accident · Minor injuriesData collectionFinal reportSchweizer 269C · Las Vegas, NVThe certificated flight instructor's delayed remedial action, and inadequate supervision while landing on a pinnacle. Factors contributing to the accident were the lack of suitable terrain for a forced landing, and the student's failure to maintain rotor rpm.NTSB ANC08FA037Accident · 1 fatalField investigationFinal reportCessna 170B · Tyonek, AKThe pilot's failure to maintain adequate airspeed to prevent a stall while maneuvering, which resulted in an uncontrolled descent and collision with terrain.NTSB CHI08CA086Accident · No injuriesData collectionFinal reportRans S-4 Coyote I · Lakeville, MNThe pilot's failure to maintain directional control and his inadequate compensation for the crosswind conditions. Factors included the pilot's lack of experience in the make and model of the airplane and the crosswind gust.NTSB ANC08LA035Accident · No injuriesLimited investigationFinal reportLearjet 35A · Aniak, AKThe captain's inadequate compensation for wind conditions during the landing flare/touchdown. Contributing to the accident were a crosswind and windshear.NTSB MIA08CA064Accident · No injuriesData collectionFinal reportClutton Eric Fred S1 · Tullahoma, TNThe pilot's failure to maintain control of the airplane during takeoff.NTSB NYC08CA098Accident · No injuriesData collectionFinal reportBeech 23 · Pineland, FLThe pilot's failure to maintain directional control of the airplane during the landing. Contributing was the gusting wind conditions.NTSB NYC08CA096Accident · No injuriesData collectionFinal reportMaule M-7-260C · Cumming, GAThe pilot's failure to maintain directional control during an aborted landing. Contributing to the accident were the gusty crosswind conditions.NTSB MIA08CA055Accident · Minor injuriesData collectionFinal reportWilliam P. Crowell Genesis · Warm Springs, GAThe failure of the pilot to maintain directional control of the airplane during final approach.NTSB DFW08CA064Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Houston, TXThe student pilot's improper use of the collective and the flight instructor's delayed remedial action, which resulted in a dynamic rollover.NTSB CHI08CA078Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Cahokia, ILThe flight instructor's failure to correct for proper runway alignment during final approach and his failure to maintain aircraft control during his subsequent go-around. Contributing to the accident was the dual-student's failure to properly align with the…NTSB ANC08CA036Accident · No injuriesData collectionFinal reportCessna 207 · Chefornak, AKThe pilot's failure to maintain control of the airplane during the landing flare/touchdown.NTSB DFW08FA061Accident · 1 fatalField investigationFinal reportCessna 210 · Baytown, TXThe pilot's failure to maintain aircraft control after flying into clouds.NTSB LAX08CA057Accident · No injuriesData collectionFinal reportRobinson R44 II · Bullhead City, AZThe pilot's misjudged landing flare, inadequate bounced landing recovery, and failure to maintain directional control during a bounced landing that resulted in the tail rotor blades colliding with a hangar. Contributing to the accident was the burned out…NTSB DFW08FA060Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Lindsay, OKThe flight instructor's failure to maintain control of the airplane, which resulted in an inadvertent stall while maneuvering.NTSB MIA08MA051Accident · 2 fatalMajor investigationFinal reportCessna 525 · West Gardiner, METhe pilot's spatial disorientation and subsequent failure to maintain airplane control.NTSB MIA08CA049Accident · Serious injuriesData collectionFinal reportAirborne Redback · Jefferson, GAThe failure of the pilot-in-command to maintain control of the airplane and his poor weather evaluation before attempting to taxi the airplane. A factor in the accident was the failure of airport personnel to correct the inaccurate wind information reported…NTSB NYC08LA087Accident · 1 fatalLimited investigationFinal reportUnknown Free Bird Sportlite · McCullough, ALThe non-certificated pilot's failure to maintain aircraft control while maneuvering. Contributing to the accident was the non-certificated pilot's improper decision to conduct a flight prior to the airplane being properly inspected and certified.NTSB NYC08CA093Accident · No injuriesData collectionFinal reportJames Dayton Pit Bull JD-3 · Leonardtown, MDThe pilot's improper flare during the landing.NTSB MIA08FA044Accident · 2 fatalField investigationFinal reportRobinson R44 · Ochopee, FLThe pilot's failure to maintain aircraft control while maneuvering. Contributing to the accident were a tailwind condition and the pilot's inadequate in-flight planning/decision.NTSB LAX08LA050Accident · 2 fatalLimited investigationFinal reportAir Creation Clipper · Green Valley, AZAn in-flight loss of control and an uncontrolled descent into terrain for undetermined reasons.NTSB DFW08FA057Accident · 1 fatalField investigationFinal reportPiper PA46-500TP · San Antonio, TXThe pilot's failure to execute an instrument approach. Contributing to the accident was the pilot's impairment due to recent use of over-the-counter medication.NTSB DFW08FA056Accident · 1 fatalField investigationFinal reportAero Commander 500B · Tulsa, OKThe pilot's loss of control due to spatial disorientation and the pilot exceeding the design/stress limits of the aircraft. Factors contributing to the accident were the pilot's reported gyro problem, the dark night conditions , and prevailing instrument…NTSB CHI08FA066Accident · 1 fatalField investigationFinal reportHawker Beechcraft 58 · Cleveland, OHThe pilot experienced spatial disorientation during the inital climb causing him to lose control of the airplane.NTSB SEA08CA059Accident · No injuriesData collectionFinal reportBell 206 B2 · La Verna, CAThe pilot's improper preflight planning which resulted in a jammed cyclic control while maneuvering.NTSB CHI08FA061Accident · 4 fatalField investigationFinal reportCessna 340 · Port Clinton, OHThe pilot's failure to maintain sufficient airspeed to avoid a stall during the landing approach.NTSB CHI08CA063Accident · No injuriesData collectionFinal reportNewbold Newbold 2000 · Newark, OHThe CFI's failure to maintain control of the gyrocopter which resulted in settling with power and the subsequent hard landing. Factors associated with the accident were the CFI's decision to excessively flare the gyrocopter at a low altitude.NTSB NYC08LA075Accident · Minor injuriesLimited investigationFinal reportDean Patrick G Genesis · Laurel, MDThe reason for this occurrence was undetermined.NTSB DEN08CA047Accident · No injuriesData collectionFinal reportCessna 152 · Loveland, COthe student pilot's premature flare resulting in the loss of aircraft control.