NTSB investigations, 2001
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 CHI01FA104Accident · Minor injuriesField investigationFinal reportAirbus Industrie A320-200 · Detroit, MIThe pilot induced oscillations and the delay in aborting the takeoff. Factors associated with the accident were the first officer used an improper trim setting and the captain did not identify and correct the setting during the taxi checklist, and the wet…NTSB MIA01WA100Accident · No injuriesForeign investigationBoeing 767-300 · Puerto Plata, Dominican RepublicNTSB MIA01LA101Accident · No injuriesLimited investigationFinal reportRobinson R22 · Okeechobee, FLan in-flight collision with the ground during a simulated engine failure, and autorotation, which resulted in the tailboom separating. A contributing factor in this accident was the pilot allowed the rotor rpm to decay which resulted in inadequate rotor rpm…NTSB MIA01FA102Accident · Serious injuriesField investigationFinal reportPiper PA-34-200 · Palm Coast, FLthe second pilot's failure to maintain Vmc during a single engine approach resulting in a loss of control in flight and subsequent collision with objects and terrain during an uncontrolled descent. Contributing to the accident was the PIC turning the right…NTSB LAX01LA126Accident · Minor injuriesLimited investigationFinal reportCessna 182E · Boulder City, NVThe loss of engine power during landing descent for undetermined reasons.NTSB CHI01LA105Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Sidney, NEthe pilot's failure to maintain directional control during the landing. A factor relating to this accident was the berm.NTSB CHI01LA103Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Port Huron, MIThe pilot not maintaing a proper glide path during the simulated forced landing. Factors were flight instructor's inadequate supervision and the wind gusts.NTSB ATL01FA040Accident · No injuriesField investigationFinal reportDouglas DC-3 · Donalsonville, GAThe failure and separation of No.12 cylinder from the engine case that resulted in an in-flight oil fed fire; and the subsequent separation of the right engine from airframe.NTSB LAX01IA118Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-88 · Tucson, AZthe failure of 4th stage turbine blades during takeoff roll, which resulted in a dynamic imbalance in the engine.NTSB FTW01LA080Accident · No injuriesLimited investigationFinal reportCessna 210D · Lawton, OKthe pilot's failure to maintain aircraft control during the landing flare/touchdown. A contributing factor was the crosswind.NTSB ATL01LA039Accident · No injuriesLimited investigationFinal reportCessna 182B · Boynton Beach, FLThe failure of a propeller actuator pin that resulted in an engine vibration and the loss of thrust. The airplane nosed over during the emergency landing roll. A factor was rough/uneven terrain.NTSB LAX01LA117Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Anza, CAThe pilot's failure to maintain control of the airplane following the opening of the cockpit/cabin door. The door came open because of improperly installed upholstery, which resulted in the inability to lock the door.NTSB LAX01LA115Accident · No injuriesLimited investigationFinal reportCessna 172N · Show Low, AZThe pilot's failure to maintain directional control resulting in an encounter with terrain and a nose over.NTSB IAD01LA037Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Huntington, WVThe pilot's inadequate preflight inspection, which resulted in residual fuel contamination and a subsequent engine failure. Factors included corroded fuel filler necks and rain the previous evening.NTSB FTW01LA078Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Oklahoma City, OKthe loss of engine power during the initial takeoff climb for an undetermined reason, which resulted in a forced landing. A contributory factor to the accident was the lack of suitable terrain for the forced landing.NTSB MIA01LA099Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Poplarville, MSa loss of engine power due to a cracked number 2 cylinder which resulted in a forced landing, subsequent impact with the runway, departure from the runway down an embankment, soft terrain and nose over.NTSB FTW01LA077Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Houston, TXthe pilot's failure to execute a go-around after becoming low on a visual approach.NTSB DEN01FA070Accident · 4 fatalField investigationFinal reportBeech A36 · Jackson Hole, WYthe pilot's continued VFR flight into instrument meteorological conditions which resulted in an inflight collision with terrain during cruise flight. Factors were the pilot's inadequate preflight planning in that he failed to familiarize himself with the…NTSB DCA01WA028Accident · No injuriesForeign investigationBoeing 727-223B · Pohnpei Island, MicronesiaNTSB SEA01LA061Accident · Minor injuriesLimited investigationFinal reportEurocopter AS-350 B2 Ecureuil · Mazama, WAThe pilot's failure to maintain aircraft control. Snow covered terrain, high and variable wind conditions, and failure of attaining the proper touchdown point were factors.NTSB MIA01LA097Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Orlando, FLa fire due to a broken and separated turbocharger exhaust which allowed hot exhaust to ignite the engine shroud.NTSB DEN01LA067Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Buffalo, WYfailure of the rotor drive system clutch assembly which rendered the aircraft uncontrollable.NTSB NYC01LA087Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Islip, NYThe certified flight instructor’s inadequate supervision and delayed remedial action, which resulted in a roll-over. Factors in this accident were the crosswind condition and soft landing area.NTSB MIA01LA096Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Brevard, NCan in-flight collision with a tree. Factors in this accident were the pilot's inadequate planned approach and excessive airspeed on the approach.NTSB LAX01LA114Accident · No injuriesLimited investigationFinal reportAir Tractor AT-802 A · Maricopa, AZInadequate selection of landing facilities and improper placement of vehicles near the runway. An additional factor was the use of a runway which resulted in a downwind landing.NTSB FTW01LA076Accident · No injuriesLimited investigationFinal reportRobinson R22 · Alvarado, TXthe pilot's failure to maintain clearance with a marked static wire.NTSB DEN01FA066Accident · 1 fatalField investigationFinal reportCessna T210L · Howard, COthe pilot's continuation of a VFR flight into instrument meteorological conditions, and his subsequent failure to maintain terrain clearance. Contributing factors were his failure to obtain a preflight weather briefing, and his failure to obtain any in-flight…NTSB CHI01LA101Accident · No injuriesLimited investigationFinal reportCessna P206 · Derby, KSThe misjudged in-flight planning the pilot had for the forced landing. Factors were the induction air ducting separation, the pilot not coordinating his emergency procedure with airfield traffic, and the trees.NTSB CHI01FA100Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Erhard, MNThe pilot's failure to maintain aircraft control. Factors relating to the accident were the pilot's encounter with known adverse weather conditions, the low ceiling, the pilot disregarding the weather observation information obtained prior to the flight, and…NTSB ATL01LA038Accident · No injuriesLimited investigationFinal reportBeech 55 · Lake Wales, FLThe pilot's failure to follow the descent and before landing checklist that resulted in fuel starvation to both engines and the subsequent loss of engine power.NTSB ATL01LA037Accident · Serious injuriesLimited investigationFinal reportCessna 182J · Durham, NCThe loss of engine power for undetermined reasons. Conditions for carburetor icing were present at the time of the accident.NTSB NYC01FA084Accident · No injuriesField investigationFinal reportHawker Siddeley HS-125-3A · Bridgeport, CTThe pilot-in-commands inadequate preflight planning resulting in an approach to a runway with insufficient length. A factor related to the accident was the slush covered runway which resulted in a hydroplaning condition.NTSB LAX01FA113Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Essex, CARupture of the fuel injection flow divider diaphragm due to improper manufacture of the raw material stock from which the diaphragm was fabricated. The diaphragm tear resulted in complete engine power loss, which required the pilot to descend into an…NTSB LAX01FA112Accident · 1 fatalField investigationFinal reportNorth American Navion · Santa Ysabel, CAthe pilot's continued VFR flight into IFR conditions, which resulted in a loss of control due to spatial disorientation.NTSB DEN01LA065Accident · No injuriesLimited investigationFinal reportErco 415-C · Ivins, UTThe unsuitable terrain on which to make a forced landing. A contributing factors was the carburetor icing conditions.NTSB SEA01LA063Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Saint Helens, ORthe pilot's improper use of the carburetor heat while attempting to determine if there was ice accumulating in the carburetor throat. Factors include flight in conditions conducive to carburetor icing, and a fence running across the field in which the forced…NTSB SEA01LA062Accident · No injuriesLimited investigationFinal reportCessna 182M · Enterprise, ORInadvertent collision with a deer while landing. A contributing factor was night conditions.NTSB SEA01FA060Accident · 1 fatalField investigationFinal reportCessna U206G · Mica, WAThe pilot's continued flight into instrument meteorological conditions. Contributing factors were fog, low ceilings, drizzle/mist, rising terrain, and the non-availability of a functioning transponder.NTSB MIA01WA098Accident · No injuriesForeign investigationCessna 525 · Hamburg, GermanyNTSB MIA01LA095Accident · No injuriesLimited investigationFinal reportCessna 172R · Cartersville, GAthe pilot's failure to maintain control of the airplane which resulted in the airplane veering off course and subsequent impact with trees.NTSB LAX01LA111Accident · No injuriesLimited investigationFinal reportCessna 140 · San Jose, CAThe failure of the pilot to maintain directional control during landing.NTSB NYC01LA083Accident · No injuriesLimited investigationFinal reportCessna 172S · Keene, NHThe pilot's failure to maintain directional control during the landing roll. A factor included the patchy snow on the runway.NTSB LAX01LA110Accident · 2 fatalLimited investigationFinal reportJones RV-6A · Inyokern, CAthe in-flight collision with mountainous terrain during a forced landing following a loss of engine power resulting from the pilot's inadequate weather evaluation, continued flight into icing weather conditions, his delay in carburetor heat use, and his delay…NTSB DEN01LA069Accident · No injuriesLimited investigationFinal reportBoeing Stearman E75 · Heber, UTUncommanded locking of the right brake, resulting in loss of control and nose over during landing.NTSB DEN01LA068Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Morgan, UTthe pilot's failure to maintain directional control during landing roll which resulted in a collision with a snow bank on the edge of the runway.NTSB DCA01WA029Accident · No injuriesForeign investigationBoeing 707 · Sao Paulo, BrazilNTSB CHI01LA099Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1C · Dekalb, ILFuel starvation, the pilot not switching the fuel selector to the other fuel tank, and the pilot not maintaining control of the airplane through the forced landing attempt. Factors relating to this accident were the pilot's inadequate fuel management, the…NTSB ANC01LA041Accident · No injuriesLimited investigationFinal reportCessna 180 · Ophir, AKThe pilot's selection of unsuitable terrain for takeoff, and his inadequate preflight planning/preparation resulting in a collision with trees during the initial climb. Factors in the accident were soft, snow-covered terrain, and trees in the area of…NTSB SEA01FA059Accident · No injuriesField investigationFinal reportde Havilland DHC-8-102 · Portland, ORThe failure of the number 5 engine bearing assembly followed by the disconnection of the P2.5/P3 switching valve to rear inlet case sealing air tube and the melting of the NL probe port (sealing tube) which allowed an oil fed fire beyond the constraints of…NTSB NYC01WA082Accident · 2 fatalForeign investigationAero Commander 500S · Kross, Iceland