NTSB investigations, 2001
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 WHERE year(c.\"eventDate\") = 2001 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 year(c."eventDate") = 2001 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 CHI02LA037Accident · 1 fatalLimited investigationFinal reportVermeys T-Bird II · Sherburn, MNThe loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin.NTSB CHI02LA030Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Hillman, MNThe inadvertent stall by the pilot. Factors were the tailwind, and the improper decision of the pilot to takeoff with a tailwind.NTSB CHI02LA027Accident · Serious injuriesLimited investigationFinal reportBeech V35 · Mounds View, MNFuel starvation caused by the pilot's improper positioning of the fuel tank fuel selector while in the traffic pattern, and the unsuitable terrain encountered during the forced landing. Factors relating to the accident were the pilot not complying with the…NTSB CHI02LA026Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Wahoo, NEThe pilot's inadequate preflight planning/preparation resulting in fuel exhaustion during cruise flight, and the unsuitable terrain for landing encountered by the pilot during the subsequent forced landing. Factors relating to the accident were the pilot's…NTSB ATL02LA012Accident · No injuriesLimited investigationFinal reportExtra Flugzeugbau EA300/L · St. Augustine, FLThe pilot of the other airplanes failure to maintain a visual lookout and yield the right-of-way to a lower airplane while landing. This resulted in an inadvertent midair collision. Contributing to the accident was reported excessive radio communication on…NTSB SEA02LA012Accident · 1 fatalLimited investigationFinal reportThurston Pitts S-1S · Eatonville, WAThe pilot's unsuccessful corrective action (recovery) from an inverted spin. A contributing factor was the pilot's encounter with the inverted spin maneuver.NTSB LAX02LA024Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Copperopolis, CAThe pilot's misjudgment of speed and altitude on final approach to landing, which resulted in a low approach and impact with a fence at the runway threshold. The impact lead to a subsequent loss of control and nose over.NTSB DEN02TA011Accident · No injuriesFinal reportCessna 206 · Casper, WYfailure to maintain aircraft control during landing. Contributing factors were the crosswind and gusting wind conditions.NTSB DEN02LA010Accident · Minor injuriesLimited investigationFinal reportAgusta A119 · Ogden, UTimproper rigging of the rotary variable differential transformer by the manufacturer, resulting in incorrect fuel scheduling to the fuel control unit.NTSB ATL02LA011Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Bunnell, FLThe pilot-in-commands (CFI) failure to follow procedures and directives (positive relinquish of flight controls from a dual student and improper flare (too high) during an autorotation) which resulted in a subsequent hard landing. Contributing to the accident…NTSB MIA02LA015Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Gainesville, FLThe failure of both pilots to insure the airplane contained adequate fuel to complete the flight resulting in loss of engine power due to fuel exhaustion and collision with trees during a forced landing.NTSB LAX02LA023Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Herald, CAThe pilot's delay initiating a go-around during a downwind approach to a short runway.NTSB DEN02LA008Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Nephi, UTThe pilot's failure to maintain clearance with the transmission wires while maneuvering. A contributing factor was the low altitude flight performed by the pilot.NTSB CHI02LA023Accident · Serious injuriesLimited investigationFinal reportTaylorcraft F19 · Backus, MNThe pilot's improper preflight planning/preparation, and his continued flight into known adverse weather conditions. Factors relating to the accident were the pilot becoming lost/disoriented in the weather, visual lookout by the pilot during the descent not…NTSB CHI02LA022Accident · No injuriesLimited investigationFinal reportSmith Aerostar 601 · Danville, ILThe separation of the main landing gear scissor assembly during landing for undetermined reasons, resulting in the directional control of the airplane not being possible.NTSB FTW02LA031Accident · Serious injuriesLimited investigationFinal reportRaytheon A36 · Crownpoint, NMThe safety pilot's failure to maintain directional control during the landing. Contributing factors were the safety pilot's lack of experience flying from the right seat and the improper retraction of the flaps during the attempted go-around.NTSB FTW02LA030Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Anton, TXThe total loss of engine power while maneuvering due to a cracked cylinder, which resulted in a forced landing. A factor was lack of suitable terrain for the forced landing.NTSB ATL02FA010Accident · 1 fatalField investigationFinal reportCessna 310Q · Winston Salem, NCImproper installation of the elevator trim tab control rod by maintenance personnel which allowed the control rod to disconnect and jam in the full up position (elevator full down) while in-flight. This resulted in a loss of directional control and subsequent…NTSB SEA02FA011Accident · 1 fatalField investigationFinal reportCessna A185F · Lucile, IDThe pilot's failure to maintain adequate altitude above, and/or clearance with, mountainous terrain during night visual flight rules flight. Factors included mountainous terrain and dark night light conditions.NTSB LAX02LA021Accident · No injuriesLimited investigationFinal reportCessna 182S · Palm Springs, CAThe failure of the pilot-in-command to maintain directional control of the airplane after encountering a dust devil during landing roll.NTSB CHI02LA031Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · New Ulm, MNThe student and flight instructor not using all of the available runway, the inadequate supervision by the flight instructor and the unsuccessful remedial action by the flight instructor. The student not attaining the proper touchdown point and the plowed…NTSB CHI02LA020Accident · No injuriesLimited investigationFinal reportMaule MX-7 · Middleton, WIthe pilot's improper rotation and failure to maintain directional control during takeoff. Additional factors were the crosswind and the soft terrain.NTSB SEA02FA009Accident · 1 fatalField investigationFinal reportCessna 175C · Miles City, MTThe separation of the number four cylinder exhaust valve guide from the cylinder head, leading to the failure of the exhaust valve stem and the catastrophic failure of the engine while in cruise flight. Factors include the necessity of attempting a forced…NTSB LAX02FA020Accident · 2 fatalField investigationFinal reportRobinson R-22 Beta · Escondido, CAthe pilot's failure to maintain an adequate clearance from obstacles while approaching to land at his private helipad. Factors in the accident were night conditions, inadequate illumination of the landing pad, and a likely low visibility condition due to fog.NTSB CHI02LA038Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Hawley, MNthe failure of the pilot to maintain directional control. A factor was the trees.NTSB CHI02LA032Accident · No injuriesLimited investigationFinal reportPiper PA-15 · Decatur, ILThe excessive braking performed by the flight instructor.NTSB CHI02LA021Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Lambertville, MIThe pilot's improper flare during landing.NTSB WAS02RA016Accident · Serious injuriesForeign investigationBell 206B · Maracaibo, VenezuelaNTSB LAX02LA022Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Avalon, CAthe total loss of engine power during departure climb for undetermined reasons.NTSB IAD02LA010Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Millbrook, NYpilot's inadvertent activation of the right brake during landing roll-out , which caused the airplane to nose over. A factor was the crosswind.NTSB DEN02LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Paonia, COimpact with a deer during initial climb immediately following rotation, resulting in the separation of the left main landing gear assembly.NTSB CHI02LA019Accident · No injuriesLimited investigationFinal reportPiper PA-32-301T · Phillips, WIThe fuel starvation encountered on takeoff and unsuitable terrain the pilot encountered during the forced landing. A factor was the fuel selector valve malfunction.NTSB NYC02LA031Accident · No injuriesLimited investigationFinal reportMaule M7-260 · North Lima, OHThe pilot's failure to retract the landing gear, which resulted in a wheels down landing on water.NTSB NYC02LA021Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Roanoke, VAThe failure of the pilot ensure the proper position of the fuel selector which resulted in fuel starvation. Factors were the improper placement of the fuel selector valve tank index, and the improper in-flight decision of the pilot to change tanks in…NTSB IAD02LA009Accident · No injuriesLimited investigationFinal reportSchleicher ASW-19 · Jersey Shore, PAThe pilot's in-flight encounter with weather, which led to a forced landing to unsuitable terrain.NTSB FTW02LA029Accident · No injuriesLimited investigationFinal reportLandoll Vans RV 3-A · Denton, TXthe pilot's failure to perform a preflight inspection, which resulted in a loss of total engine power due to oil starvation. A contributing factor was the lack of suitable training for the forced landing.NTSB FTW02FA028Accident · 1 fatalField investigationFinal reportRobinson R22 · Seagoville, TXthe flight instructor's failure to maintain clearance with wires while maneuvering along a river.NTSB ATL02LA009Accident · 1 fatalLimited investigationFinal reportBass Moni · Locust Grove, GAThe pilot's failure to maintain airspeed during a low-altitude aerobatic maneuver, which resulted in an inadvertent stall/spin and subsequent uncontrolled descent into terrain.NTSB ATL02FA008Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · McEwen, TNThe pilot initiated a VFR flight into known IMC conditions which resulted in a loss of control of the airplane due to spatial disorientation. Factors were the low ceilings.NTSB SEA02LA010Accident · No injuriesLimited investigationFinal reportFetherolf Hatz CB-1 · Ontario, ORAn improper weld in the landing gear, resulting in separation of the right main landing gear wheel during a normal landing.NTSB NYC02LA024Accident · No injuriesLimited investigationFinal reportCessna 172D · Argyle, NYThe pilot's failure to maintain aircraft control while maneuvering.NTSB NYC02LA023Accident · No injuriesLimited investigationFinal reportBeech 1900C · Bar Harbor, MEA deer, which had been crossing the runway as the airplane touched down. A factor was the dark night conditions.NTSB FTW02IA027Incident · No injuriesIncident investigationFinal reportAirbus Industrie A319-132 · Midland, TXthe #1 engine's fatigue failure of the #3 bearing due to the manufacturer's inadequate design of the high-pressure compressor stubshaft coating, which resulted in a loss of engine power and an emergency landing.NTSB CHI02LA018Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Peoria, ILThe gear collapse for undetermined reasons during the landing roll. A factor was the pilot not using a proper touchdown point by landing long.NTSB LAX02FA019Accident · 1 fatalField investigationFinal reportCessna 182S · Little River, CAthe pilot's continued VFR flight into instrument meteorological conditions, which resulted in a collision with trees and terrain.NTSB DCA02WA006Accident · Serious injuriesForeign investigationBoeing 737-300 · Nairobi, KenyaNTSB NYC02LA022Accident · No injuriesLimited investigationFinal reportMooney M20S · Buckhannon, WVThe CFI's improper flare, which resulted in a hard landing.NTSB CHI02LA017Accident · No injuriesLimited investigationFinal reportLuscombe LL-8-E · Bellaire, MIthe unsuitable terrain for landing selected by the pilot. A factor was the soft terrain.NTSB ATL02LA014Accident · No injuriesLimited investigationFinal reportCessna 152 · Elberton, GAThe student pilot's in-flight decision to land in a field, which resulted in an on-ground collision with a berm. Factors were the student's inadequate training and inadequate supervision by the flight instructor on the ground.NTSB NYC02LA038Accident · No injuriesLimited investigationFinal reportAero Vodochody Aero. Works L-39C · Wilmington, DEA ruptured oil line, which resulted in oil spraying onto the APU exhaust and a subsequent fire.