NTSB investigations
173 cases where the sequence of events included Simulated/training event.
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '600' 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.
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '600' 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
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 ERA09CA234Accident · No injuriesData collectionFinal reportCessna 172RG · Charleston, SCThe pilot's failure to extend the landing gear before landing. Contributing to the accident was the diversion of the pilot's attention to an airplane on a converging final approach course.NTSB CEN09CA228Accident · Minor injuriesData collectionFinal reportRemos Remos GX · St. Charles, MOThe pilot's failure to maintain a proper glide path and airspeed during a simulated emergency approach. Contributing to the accident was the flight instructor's delayed remedial action.NTSB CEN09CA203Accident · No injuriesData collectionFinal reportBell 407 · Lancaster, TXThe failure of the pilot to maintain adequate main rotor rpm and the failure of the CFI to provide appropriate instruction during the maneuver.NTSB ERA09LA173Accident · 1 fatalLimited investigationFinal reportHughes 369F · Moyock, NCThe flight instructor's failure to verify that the helicopter's skid was clear of an obstruction while demonstrating a one-skid and toe-in landing maneuver. Contributing to the accident was the flight instructor's decision to practice this maneuver at an…NTSB WPR09CA118Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta II · Encinitas, CAA partial loss of engine power for an undetermined reason. Contributing to the accident was the soft terrain.NTSB ERA09CA175Accident · No injuriesData collectionFinal reportCessna 172 · Reidsville, GAThe pilot's failure to maintain control of the airplane during an attempted recovery from a stall/spin.NTSB CEN09CA162Accident · Minor injuriesData collectionFinal reportCameron Balloons V-77 · Terre Haute, INThe loss of the burner pilot light during approach to the landing area and the pilot's failure to relight the burner using alternate sources.NTSB CEN09CA157Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Cypress, TXThe student pilot's failure to maintain adequate main rotor rpm and the instructor's delayed remedial action.NTSB CEN09CA148Accident · No injuriesData collectionFinal reportCessna 172 · Union Mills, INThe certificated flight instructor's failure to follow correct engine clearing procedures. A factor was the unsuitable landing area.NTSB CEN09CA067Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta II · Erie, COthe pilot's improper flare during the practice autorotation which resulted in a hard landing. Contributing factors were the flight instructor's delayed remedial action and inadequate supervision.NTSB WPR09CA030Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Friant, CAThe student pilot's failure to execute a go-around in timely manner, which resulted in a collision with terrain. Also causal was the instructor's inadequate supervision of the flight and delayed remedial actions.NTSB WPR09CA023Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Temecula, CAThe certified flight instructor's failure to maintain adequate rotor rpm during a simulated approach to landing under variable wind, and high density altitude conditions.NTSB MIA08CA202Accident · Minor injuriesData collectionFinal reportSchweizer 269C-1 · Titusville, FLThe flight instructor's delayed remedial action during a simulated autorotation.NTSB MIA08LA199Accident · No injuriesLimited investigationFinal reportEurocopter AS-350-BA · Linden, NJThe flight instructor’s delayed remedial action (flight control inputs) during a practice autorotation/run-on landing resulting in fracture damage to the main rotor system Starflex.NTSB DFW08FA234Accident · No injuriesField investigationFinal reportCessna E162 · Douglas, KSThe airplane's inability to recover from an intentional spin, despite proper control inputs by the flight test pilot. Contributing to the accident was the failure of the airplane's ballistic parachute system to properly deploy.NTSB ANC08LA083Accident · No injuriesLimited investigationFinal reportBell UH-1B · Iliamna, AKThe failure of company maintenance personnel to ensure the helicopter was properly maintained, resulting in a severe in-flight vibration due to collective bounce. Contributing to the accident was loose and worn bearings on the helicopter's stabilizer bar,…NTSB LAX08LA206Accident · No injuriesLimited investigationFinal reportCessna 172N · El Cajon, CAThe loss of engine power due to carburetor ice resulting from the flight instructor's failure to use the carburetor heat when simulating an engine failure. Contributing to the accident were the carburetor icing weather condition and the lack of suitable…NTSB NYC08CA230Accident · No injuriesData collectionFinal reportCessna 172 SP · Stevensville, MDThe flight instructor's delayed decision to go around.NTSB LAX08LA191Accident · 2 fatalLimited investigationFinal reportCessna 172S · Oceanside, CAFailure of the pilot to regain airplane control during an intentional stall/spin maneuver.NTSB DEN08CA099Accident · No injuriesData collectionFinal reportPiper Seneca · Plaquemine, LAThe certified flight instructor's poor decision to simulate a loss of engine on takeoff with a wet runway and the pilot's failure to maintain directional control. Contributing to the accident was the dew covered runway surface and the ditch.NTSB NYC08TA183Accident · Minor injuriesFinal reportRobinson R44 II · Lake Wales, FLThe pilot's improper recovery from a practice autorotation.NTSB MIA08FA091Accident · 1 fatalField investigationFinal reportAeroFab Lake LA-250 · Skaneateles, NYThe certified flight instructor's failure to maintain airspeed during a steep turn.NTSB NYC08FA143Accident · 2 fatalField investigationFinal reportBeech BE-76 · Rome, GAThe flight instructor's failure to maintain aircraft control while maneuvering during a simulated engine failure. Contributing to the accident was the flight instructor's lack of total experience as a multiengine flight instructor.