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 IAD02FA037Accident · 4 fatalField investigationFinal reportCessna 172P · Ocean City, MDThe pilot's spatial disorientation, which resulted in his subsequent loss of control of the airplane. A factor was the dark night, over water visual conditions.NTSB FTW02LA096Accident · Minor injuriesLimited investigationFinal reportMooney M20A · Norman, OKMaintenance personnel's improper clamp installation on the mixture control cable, which resulted in a loss of engine power.NTSB DEN02LA033Accident · Serious injuriesLimited investigationFinal reportCessna 172Q · Fruitland, UTthe pilot's failure to apply carburetor heat. Contributing factors included carburetor icing conditions, the unavailability of suitable terrain on which to make a forced landing, and night conditions.NTSB ATL02LA064Accident · 1 fatalLimited investigationFinal reportKopp Robert E GYRO-KOPP-TER · Citra, FLThe pilots failure to maintain flight control, followed by a subsequent collision with the terrain.NTSB WAS02WA034Accident · No injuriesForeign investigationSchweizer 269C · Auckland, New ZealandNTSB LAX02LA112Accident · No injuriesLimited investigationFinal reportMaule M-7-260 · Montague, CAThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control.NTSB LAX02LA109Accident · 1 fatalLimited investigationFinal reportTrenti RV-4 · Jacumba, CAin-flight loss of control for undetermined reasons.NTSB LAX02LA107Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Santa Clarita, CAThe pilot performed inadequate planning and inaccurate fuel computations, and intiated flight without refueling. This resulted in a forced landing on a road at night due to fuel exhaustion.NTSB LAX02FA110Accident · 1 fatalField investigationFinal reportPilatus UV-20A · Marana, AZthe failure of both pilots to maintain an adequate visual lookout. The failure of the Pilatus pilot to report his proper position was a factor.NTSB DEN02LA038Accident · No injuriesLimited investigationFinal reportCessna T337D · St. George, UTthe pilot's misjudged landing flare, which resulted in an inadvertent stall/mush and a hard landing.NTSB CHI02FA093Accident · 1 fatalField investigationFinal reportCessna 208B · Alma, WIThe pilot not removing the ice contamination from the airplane prior to departure and the pilot intentionally flying into known severe icing conditions, resulting in the aircraft not being able to maintain altitude/clearance from the terrain. Factors to the…NTSB SEA02LA054Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Rainier, WAThe pilot's failure to maintain the proper decent rate on approach. A factor was the trees in close proximity to the airport.NTSB MIA02FA067Accident · 1 fatalField investigationFinal reportPiper PA32R-300 · Broadway, NCThe pilot's inadequate visual lookout and his failure to maintain obstacle clearance.NTSB LAX02FA108Accident · Serious injuriesField investigationFinal reportBeech E90 · Reno, NVThe pilot's inadequate approach airspeed for the existing adverse meteorological conditions followed by his delayed remedial action to avert stalling and subsequent loss of airplane control. Contributing factors were the pilot's reduced visibility due to the…NTSB FTW02LA094Accident · No injuriesLimited investigationFinal reportCessna 402C · Albuquerque, NMThe failure of the tug driver to stop at the stop sign resulting in a collision with a taxiing airplane. A contributing factor was the dark night light conditions.NTSB FTW02IA097Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2B19 · Tulsa, OKThe failure of the horizontal stabilizer control system for undetermined reasons.NTSB CHI02LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Christopher, ILThe in-flight collision with a Canadian goose, which caused substantial damage to the airplane's right wing. A factor to the accident was the dark night light condition.NTSB ATL02IA065Incident · No injuriesIncident investigationFinal reportBeech C24R · Greenville, MSAn overload failure of the nose gear assembly for undetermined reasons.NTSB FTW02LA093Accident · No injuriesLimited investigationFinal reportTillman Long EZ · Lockhart, TXthe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW02FA095Accident · 2 fatalField investigationFinal reportPiper PA-28RT-201T · Marianna, ARThe pilot's continued flight into adverse weather conditions and his failure to maintain clearance with terrain while maneuvering. Factors were, the low cloud and mist weather conditions, and the dark night light conditions.NTSB CHI02LA091Accident · Minor injuriesLimited investigationFinal reportAviat Pitts S-2B · Milwaukee, WIThe loss of engine power for undetermined reasons. A factor in the accident was the telephone pole.NTSB CHI02LA090Accident · No injuriesLimited investigationFinal reportCessna 182J · Springfield, ILThe pilot not maintaining clearance from a fence while taxiing. The fence was a factor.NTSB ANC02LA022Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Fairbanks, AKThe pilot's failure to complete his prelanding checklist, and a subsequent inadvertent wheels up landing.NTSB SEA02GA053Accident · 3 fatalFinal reportPiper PA-31 · Atlanta, IDThe pilot's failure to maintain aircraft control while in cruise flight which resulted in the in-flight separation due to overload of the spar at the right wing root. Hypoxia was a factor.NTSB FTW02LA092Accident · Minor injuriesLimited investigationFinal reportSchleicher AS-W19 · Moriarty, NMThe pilot's attempt to perform a turn upwind at a altitude too low to complete the turn. A factor was the turbulance.NTSB FTW02LA091Accident · No injuriesLimited investigationFinal reportCessna 402C · Albuquerque, NMThe failure of the left main landing gear scissors assembly which resulted from improper maintenance.NTSB WAS02WA027Accident · No injuriesForeign investigationSikorsky S-76C+ · Blackbushe, United KingdomNTSB DEN02FA030Accident · 1 fatalField investigationFinal reportMooney M20C · Glenwood Sprngs, COthe pilot's failure to maintain aircraft control due to spatial disorientation, resulting in a collision with terrain. Contributing factors were the pilot's lack of an instrument rating and the dark night conditions.NTSB LAX02LA106Accident · No injuriesLimited investigationFinal reportCessna 172M · Tucson, AZthe pilot's misjudged landing flare and improper bounced landing recovery.NTSB IAD02LA036Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 1-26A · Strausburg, VAThe pilot's inadequate evaluation of weather resulted in a loss of thermal lift, which resulted in an impact with trees.NTSB DEN02LA031Accident · No injuriesLimited investigationFinal reportDoyle Kitfox III · Windsor, COloss of engine power due to restricted fuel flow for reasons undetermined. A contributing factor was the unsuitable terrain on which to make a forced landing.NTSB SEA02LA052Accident · No injuriesLimited investigationFinal reportSkystar Kitfox Lite Squared · Caldwell, IDThe pilot's failure to adequately compensate for the wind conditions. High and gusting winds were a factor.NTSB NYC02FA068Accident · 1 fatalField investigationFinal reportCessna T210N · Teterboro, NJImproper maintenance by other maintenance personnel, which resulted in the air filter element being sucked into and blocking the turbocharger inlet, and a subsequent power loss. Factors in the accident were the pilot's failure to maintain airspeed and the…NTSB DCA02MA026Accident · No injuriesMajor investigationFinal reportCanadair CL-600-2B19 · Dulles Airport, VAthe airplane's collision with two wild turkeys.NTSB ATL02FA063Accident · 2 fatalField investigationFinal reportPiper PA-28-160 · Laurens, SCThe pilot experienced spatial disorientation, which resulted in a loss of control and the subsequent collision with terrain. Factors were low clouds and dark-night.NTSB ATL02FA062Accident · 2 fatalField investigationFinal reportEurocopter France AS355 F1 · Savannah, GAThe pilot's failure to follow operating procedures and, experienced spatial disorientation while attempting a night landing to an offshore platform. A factor was a dark night.NTSB SEA02LA051Accident · No injuriesLimited investigationFinal reportBell/Garlick UH-1H · Dayton, WAA loss of power for undetermined reason(s). Contributing factors were the pilot's delayed decision to jettison the empty bucket and the trees impacted during the auto-rotation landing.NTSB NYC02LA069Accident · No injuriesLimited investigationFinal reportPiper P46T · Philadelphia, PAThe pilot's improper recovery from a bounced landing. A factor was the pilot's failure to flare during initial touchdown.NTSB LAX02TA105Accident · No injuriesFinal reportPiper PA-18-150 · Winnemucca, NVThe pilot's inadequate fuel consumption calculations that lead to fuel exhaustion.NTSB CHI02LA087Accident · No injuriesLimited investigationFinal reportCessna 182H · West Plains, MOThe engine failure due to the fatigue fracture of the crankshaft which resulted from the installation of improper pistons during an STC'd engine conversion by other maintenance personnel. Additional factors included the unsuitable terrain encountered by the…NTSB CHI02FA088Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Niles, MIFlight into known adverse weather conditions by the pilot and the spatial disorientation of pilot. Contributing factors were the lack of certification by the pilot and the weather conditions.NTSB ATL02LA061Accident · 1 fatalLimited investigationFinal reportMoore Sammie M-Breezy · Pell City, ALThe pilot's failure to maintain flying speed, followed by an inadvertent stall spin, and subsequent collision with terrain.NTSB MIA02LA180Accident · No injuriesLimited investigationFinal reportCessna 172M · Kissimmee, FLThe pilot's failure to maintain the proper clearance while taxing the airplane which resulted in the left wing tip colliding with an object and damage to the airplane. A related factor was night conditions.NTSB LAX02LA125Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Dixon, CAThe pilot lost directional control due to the unsuitable landing area. A contributing factor was the muddy runway condition.NTSB LAX02LA104Accident · No injuriesLimited investigationFinal reportCessna 172L · Bullhead City, AZThe pilot's failure to comply with maintenance/inspection requirements that resulted in a propeller failure.NTSB LAX02LA103Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Coalinga, CAthe pilot's failure to maintain directional control and his inadequate compensation for the wind conditions. The crosswind was a contributing factor.NTSB SEA02LA050Accident · No injuriesLimited investigationFinal reportUnander Velocity 173RG · West Jordan, UTThe pilot's failure to ensure that the gear was extended prior to landing. Factors included a failure of a hydraulic down-pressure switch, and the pilot's attention diverted to another aircraft executing an opposite-direction traffic pattern.NTSB MIA02FA066Accident · 2 fatalField investigationFinal reportCessna 172N · Bunnell, FLInadequate maintenance inspection of the airplane by comapny maintenance personnel which resulted in corrosion in an aileron control cable going undetected, failure of the aileron control cable, and impact with terrain following loss of control of the…NTSB LAX02FA101Accident · 3 fatalField investigationFinal reportCessna 425 · San Jose, CAthe pilot's loss of control and resulting exceedence of the design stress limits of the aircraft, which led to an in-flight structural failure. The pilot's loss of control was due in part to the loss of primary airspeed reference resulting from pitot tube…NTSB FTW02LA090Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Melbourne, ARthe pilot's failure to maintain directional control as a result of becoming incapacitated due to a stroke while taxiing for takeoff.