NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
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 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 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 WPR09LA036Accident · No injuriesLimited investigationFinal reportCessna 680 · Los Angeles, CAFailure of the ground service vehicle driver to maintain adequate clearance/distance from the taxiing airplane.NTSB WPR09CA037Accident · No injuriesData collectionFinal reportCessna 182S · White Swan, WACollision with terrain while maneuvering for undetermined reasons.NTSB ERA09LA051Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 · San Juan, PRThe detachment of the forward left servo control tube upper rod end attachment bolt during a hover due to separation of its retaining nut for undetermined reasons.NTSB ERA09LA047Accident · Minor injuriesLimited investigationFinal reportBell 206B · Boynton Beach, FLA loss of engine power due to an undertorqued air line fitting to the fuel control.NTSB ERA09CA048Accident · No injuriesData collectionFinal reportCessna 172 · Groton, CTThe student pilot's failure to maintain directional control during landing.NTSB CEN09LA056Accident · 1 fatalLimited investigationFinal reportCessna 182M · Basalt, COThe non-instrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in his loss of control of the airplane in flight.NTSB CEN09LA054Accident · 1 fatalLimited investigationFinal reportCessna 177RG · Mena, ARThe pilot's failure to maintain clearance from rising terrain. Contributing to the accident was the pilot's continued flight into deteriorating weather conditions.NTSB CEN09CA058Accident · No injuriesData collectionFinal reportMooney M20E · San Antonio, TXThe failure of the pilot to lower the gear before landing. Contributing to the accident was the pilot's failure to complete the before landing checklist.NTSB WPR09CA035Accident · No injuriesData collectionFinal reportCessna 305A · El Cajon, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA09WA049Accident · Serious injuriesClass 5 · ForeignCirrus SR22 · Turriaco, ItalyOn November 10, 2008, at 1824 universal coordinated time, a Cirrus SR22, German registration D-EPRM, was substantially damaged during a forced landing in Turriaco, Italy. The Italian certificated private pilot was seriously injured and the three passengers…NTSB ERA09CA058Accident · No injuriesData collectionFinal reportCessna 172 · Gulf Shores, ALThe pilot's improper flare during landing.NTSB DCA09RA010Accident · No injuriesForeign investigationBoeing · Ciampino, ItalyaNTSB WPR09FA034Accident · 4 fatalField investigationFinal reportPiper PA-32S-300 · Forest Falls, CAThe pilot's continued flight into instrument meteorological conditions and subsequent impact with mountainous terrain.NTSB ERA09CA070Accident · No injuriesData collectionFinal reportCessna 172RG · Manville, NJThe pilot's improper flare, which resulted in a nose-wheel-first landing.NTSB ERA09CA045Accident · No injuriesData collectionFinal reportRandall Amanda Rotorway · Middletown, DEThe student pilot’s excessive use of cyclic during the engine run-up. Contributing to the accident were the student pilot’s lack of overall experience and the gusting wind conditions.NTSB CEN09IA057Incident · No injuriesIncident investigationFinal reportCessna T210N · Lubbock, TXAn unidentified anomaly within the airplane's electrical system. Contributing to the incident was the pilot's failure to manually extend the landing gear.NTSB WPR09CA041Accident · No injuriesData collectionFinal reportWSK PZL Mielec M-18A · Mountain Home, IDThe pilot's inadequate preflight inspection, and, his failure to properly secure the aircraft as he left the cockpit with the engine operating, which resulted in the unoccupied airplane inadvertently becoming airborne and colliding with a fence and terrain.NTSB CEN09LA055Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Nacogdoches, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ANC09CA010Accident · No injuriesData collectionFinal reportCessna 172M · Girdwood, AKThe pilot's decision to attempt to take off on a snow-covered runway. Contributing to the accident was the snow-covered runway.NTSB WPR09WA042Accident · 4 fatalForeign investigationPiper PA31-350 · Bathurst, Australia, AustraliaOn November 7, 2008, approximately 0930 coordinated universal time (UTC), a Piper PA-31-350, Australian registration VH-OPC, shortly after take-off, collided with terrain about three nautical miles north of the Bathurst Airport, New South Wales, Australia.…NTSB WPR09LA032Accident · 1 fatalLimited investigationFinal reportUniversal Globe · Wallace, CAThe pilot's incapacitation during cruise for unknown reasons that resulted in a loss of aircraft control.NTSB WPR09IA033Incident · No injuriesIncident investigationFinal reportBoeing 737-700 · Salt Lake City, UTThe tug driver's failure to maintain situational awareness during the push back operation.NTSB ERA09LA043Accident · 1 fatalLimited investigationFinal reportMiller J Kirtley RV-6 · Martinsville, VAThe pilot's failure to maintain aircraft control during the initial climb after an aborted landing. Contributing to the accident was the pilot's impairment from an over-the-counter sedating antihistamine.NTSB ERA09FA039Accident · 3 fatalField investigationFinal reportPartenavia P.68C · Gainesville, FLThe pilot's failure to maintain the proper glidepath during an instrument-landing-system (ILS) approach. Contributing to the accident were the pilot's decision to initiate the ILS approach with weather below the published minimums, and the pilot's…NTSB ERA09CA044Accident · Minor injuriesData collectionFinal reportQuicksilver II Mxlii · Knoxville, PAThe reason for this occurrence was undetermined.NTSB ERA09CA041Accident · Serious injuriesData collectionFinal reportCessna 172 · Frederick, MDThe passenger’s failure to avoid the rotating propeller after exiting the airplane. Contributing to the accident was the pilot’s failure to include deplaning procedures as part of the passenger safety briefing.NTSB DCA09FA009Accident · No injuriesField investigationFinal reportGeneral Atomics MQ-9 · Sierra Vista, AZthe failure of the pilot to timely flare the aircraft to the appropriate attitude, likely associated with the different sight picture after switching cameras, resulting in a bounced landing; and the evaluator pilot’s lack of timely recognition and…NTSB ERA09CA038Accident · No injuriesData collectionFinal reportBeech 35-C33 · Atlanta, GAThe pilot’s failure to maintain a proper glide path during the final approach, resulting in a collision with the airport approach lights.NTSB DCA09RA007Accident · 14 fatalForeign investigationLearjet 45 · Mexico City, MexicoOn November 4, 2008, at 1846 central standard time, a Learjet model 45, registration XC-VMC, impacted terrain and buildings while on approach to Benito Juárez Mexico City International Airport (MMMX), Mexico City, Mexico. The 9 passengers and crew onboard the…NTSB CEN09LA051Accident · Serious injuriesLimited investigationFinal reportJohnson Leonard G Cozy MK-IV · Osceola, MOA total loss of engine power due to an obstruction of airflow as a result of the pilot's inadvertent actuation of the landing brake.NTSB CEN09CA053Accident · No injuriesData collectionFinal reportCessna 172F · Hutchinson, MNThe bird that the airplane struck while on final approach.NTSB ERA09CA042Accident · Minor injuriesData collectionFinal reportSundt Daniel N Rotorway Exec 162-F · West Chester, PAThe pilot's failure to maintain an adequate clearance above terrain while performing a pedal turn.NTSB CEN09RA052Accident · 1 fatalForeign investigationBeech 200 · Punta Chivato, MexicoOn November 3, 2008 at approximately 1800 pacific standard time (PST) a twin-engine turbo prop, Beechcraft BE200, N200JL, was destroyed when it impacted terrain shortly after takeoff from Punta Chivato Airstrip, located near Punto Chivato, Baja California…NTSB CEN09CA049Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Blaine, MNThe deer impacting the airplane during takeoff roll.NTSB ERA09FA036Accident · 1 fatalField investigationFinal reportRobinson R-44 · Gallatin, TNThe pilot's inadvertent descent into water as a result of the dark night and limited outside visual references.NTSB CEN09CA048Accident · No injuriesData collectionFinal reportCessna 152 · Spring, TXFailure of the student pilot to apply appropriate actions following a bounced landing.NTSB WPR09CA031Accident · No injuriesData collectionFinal reportPiper PA-22-135 · San Manuel, AZThe pilot's failure to maintain lateral aircraft control that resulted in collision with terrain during landing.NTSB ERA09CA040Accident · Minor injuriesData collectionFinal reportFox Jack G Mong Biwin · Thomasville, NCThe builder’s failure to set adequate propeller pitch during propeller installation.NTSB CEN09WA090Accident · 3 fatalForeign investigationPiper 34-200T · Graz, AustriaThis investigation is under the jurisdiction and control of the Austrian government. Any further information may be obtained from: Federal Office of Transport Accident investigation Branch, Department Aviation Postfach 207, 1000 Wien Lohnergasse 9, 1210 Wien…NTSB CEN09CA079Accident · No injuriesData collectionFinal reportPiper PA18-150 · Colorado Springs, COLoss of directional control due to an encounter with a weather phenomena at rotation.NTSB CEN09CA050Accident · No injuriesData collectionFinal reportAeronca 7CCM · Chadron, NEThe pilot's failure to maintain direction control of the airplane. Contributing to the accident was the pilot's lack of experience.NTSB CEN09CA046Accident · No injuriesData collectionFinal reportHemp Timothy Legacy 200 · Socorro, NMFailure of the pilot to land with sufficient runway to stop the airplane on the runway. Contributing to the accident was the airplane's speed on final approach.NTSB ANC09LA009Accident · Minor injuriesLimited investigationFinal reportConstrucciones Aeronauticas CASA-212 · Toksook Bay, AKThe flight crew’s inability to adjust/increase power to the right engine during the landing approach due to an in-flight disconnect of the engine power control linkage, resulting in a loss of control of the airplane. Contributing to the accident was the…NTSB ERA09WA037Accident · 3 fatalForeign investigationBeech 65A90 · Timehri, GuyanaNTSB ERA09LA050Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Lawrenceville, GAThe failure of the nose gear drag link bolt due to reversed bending fatigue.NTSB ERA09LA033Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Plymouth, NCThe Piper Dakota (PA-28-236) pilot's failure to see and avoid the Piper Cherokee (PA-32-260).NTSB ERA09CA035Accident · No injuriesData collectionFinal reportCessna 172 · Asheville, NCThe student pilot’s improper recovery from a bounced landing.NTSB ERA09CA034Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-5B · Bridgeport, CTThe pilot's loss of directional control during landing and while suffering symptoms of vertigo.NTSB CEN09CA047Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Lamar, COThe student pilot's failure to maintain directional control during landing.NTSB CEN09CA045Accident · No injuriesData collectionFinal reportHartter Lenny J Bearhawk · Mack, COThe collapse of the left main landing gear which resulted in the pilot's failure to maintain directional control.