NTSB investigations, 2001
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 NYC01FA064Accident · 1 fatalField investigationFinal reportCessna 310R · Bluefield, WVThe pilot's failure to execute the published missed approach procedure. A factor was heavy snowfall during the approach.NTSB FTW01IA061Incident · No injuriesIncident investigationFinal reportBell 206-L3 · Wc 368fuel exhaustion during approach due to the pilot's failure to refuel.NTSB FTW01FA048Accident · 1 fatalField investigationFinal reportBell 206B · Mineral Wells, TXthe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN01LA040Accident · No injuriesLimited investigationFinal reportCessna 150F · Meeker, COFuel exhaustion due to the failure of the instructor to ensure there was sufficient fuel for the flight. Factors were the instructor's inadequate supervision of the student pilot, and the deep snow-covered terrain.NTSB CHI01LA066Accident · Minor injuriesLimited investigationFinal reportBombardier CL-600-2B19 · Detroit, MIThe vehicle driver's inadvertent failure to place the column shifter into the parking gear. A factor to the accident was the vehicle.NTSB SEA01LA036Accident · No injuriesLimited investigationFinal reportCessna 172K · Troutdale, ORThe pilot's failure to adequately compensate for wind conditions while taxiing the airplane.NTSB MIA01LA059Accident · No injuriesLimited investigationFinal reportCessna 182A · Parkton, NCThe loss of engine power during a normal descent due to fuel starvation for undetermined reasons.NTSB MIA01LA057Accident · No injuriesLimited investigationFinal reportMooney M-20C · Jacksonville, FLThe failure of maintenance personnel to properly reconnect the aircraft's elevator control system, resulting in an in-flight disconnection of the elevator control and jamming of the rudder control during climb, the subsequent in-flight loss of control, and…NTSB MIA01LA056Accident · Serious injuriesLimited investigationFinal reportMaule MXT-7-180A · Perry, FLThe loss of control on landing due to the student's improper recovery from a bounced landing, and the resulting nose over on the grass runway.NTSB LAX01FA070Accident · 2 fatalField investigationFinal reportCessna 172F · San Luis Obispo, CAThe pilot's failure to maintain a proper climb rate to VFR conditions on-top.NTSB IAD01LA024Accident · No injuriesLimited investigationFinal reportCessna 172P · Concord, NHThe flight instructor's improper decision to land downwind on the snow and ice covered runway with a tailwind, and his failure to perform a go-around. Factors in the accident were the tailwind and the snow and ice on the runway.NTSB IAD01LA023Accident · No injuriesLimited investigationFinal reportCessna 172S · Lincoln Park, NJthe pilot's failure to maintain proper runway alignment during landing. Factors in the accident were the night lighting and the snow bank.NTSB DEN01LA039Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Spanish Fork, UTImproper weather evaluation by both the pilot and pilot/passenger, and the pilot's inadvertent VFR flight into IMC resulting in his spatial disorientation. Factors were the pilot rated passenger's spatial disorientation, fog, and night conditions.NTSB SEA01LA035Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Eastsound, WAThe pilot's failure to use carburetor heat prior to reducing engine power to idle while operating in serious carburetor icing conditions. Factors include serious carburetor icing conditions, and trees in the area where the pilot found it necessary to attempt…NTSB LAX01IA073Incident · No injuriesIncident investigationFinal reportBoeing 747-200F · Honolulu, HIthe failure of the lighting dimmer switch or circuit components for undetermined reasons, which resulted in smoke in the cockpit.NTSB FTW01LA064Accident · No injuriesLimited investigationFinal reportCessna 172 · Pine Bluff, ARthe pilot's failure to maintain directional control during the forced landing on a gravel road. Contributing factors were the pilot's delay in using carburetor heat and the loose gravel.NTSB DCA01WA012Accident · No injuriesForeign investigationBoeing 727-100 · Dundo, AngolaNTSB MIA01LA055Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Cleveland, TNThe PIC's failure to follow safe operating procedures for the maintenance of the rotorcraft's external aerial application equipment, resulting in inadvertent activation of collective as he egressed the rotorcraft, causing unmanned flight, in-flight break-up,…NTSB LAX01LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Livermore, CAThe student pilot's inadequate compensation for a tailwind during final approach and her improper recovery from a bounced landing.NTSB FTW01LA046Accident · No injuriesLimited investigationFinal reportCessna 177RG · Del Rio, TXThe pilot's inadequate compensation for the winds. A factor was the windshear.NTSB IAD01LA022Accident · No injuriesLimited investigationFinal reportLearjet 35 · Schenectady, NYThe pilot's improper trim setting, which resulted in a runway overrun and impact with a fence.NTSB FTW01LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Bristow, OKThe pilot's inadequate compensation for the crosswind conditions, which resulted in the airplane striking a snow bank during the landing flare/touchdown. A factor was the crosswind weather condition.NTSB DEN01LA038Accident · No injuriesLimited investigationFinal reportAviat A-1A · Eden, UTthe pilot's failure to maintain aircraft control during a landing attempt. A contributing factor was his failure to check the snow conditions in the field before the flight.NTSB CHI01LA060Accident · No injuriesLimited investigationFinal reportCessna 172S · Sioux Falls, SDAircraft directional control not being maintained by the student pilot during the takeoff roll. Factors to the accident were the snow bank and the student pilot's lack of total experience.NTSB NYC01IA072Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Covington, KYMissing exhaust nozzle bolts for undetermined reasons. A factor was inadequate maintenance inspection of the affected area.NTSB ANC01LA028Accident · No injuriesLimited investigationFinal reportCessna 172 · Atmautluak, AKThe pilot's failure to maintain a proper glidepath during final approach. A factor associated with the accident was soft terrain.NTSB MIA01LA054Accident · No injuriesLimited investigationFinal reportBeech 200 · Naples, FLThe failure of the pilot to obtain assistance from the FBO in the form of a marshaller and failure of the pilot to maintain clearance resulting in the on-ground collision with the light pole.NTSB IAD01WA025Accident · 3 fatalForeign investigationBell 206L4 · Mussoorie, IndiaNTSB LAX01LA068Accident · No injuriesLimited investigationFinal reportWallace Rotorway Exec 152 · Placerville, CAThe failure of the student pilot to maintain adequate ground clearance while hovering.NTSB CHI01LA061Accident · No injuriesLimited investigationFinal reportMooney M20S · Port Huron, MIThe pilot failed to maintain directional control of the airplane and the runway selected resulted in a tailwind condition. Factors associated with the accident were the gusty crosswind and the snow bank.NTSB CHI01LA057Accident · No injuriesLimited investigationFinal reportCessna 172N · Lincoln, ILThe pilot's failure to maintain directional control on the runway. Factors relating to this accident were the aborted takeoff attempt, the pilot's improper in-flight planning/decision, and the snowbank.