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 LAX02LA048Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Groveland, CAThe pilot's collision with an unobserved animal that entered the active runway during the dark nighttime when the pilot's visibility was diminished.NTSB LAX02LA047Accident · No injuriesLimited investigationFinal reportBeech 95 · Kingman, AZthe pilot's failure to complete and verify the prelanding checklist and extend the landing gear, which resulted in the gear-up landing.NTSB LAX02FA049Accident · 1 fatalField investigationFinal reportCessna T210L · San Jacinto, CAThe pilot's loss of situational awareness and his failure to adhere to the prescribed instrument approach procedures, including the track and altitudes flown. The underlying reasons for the pilot's loss of situational awareness are unknown.NTSB ANC02IA007Incident · No injuriesIncident investigationFinal reportDouglas DC-8-71F · Anchorage, AKThe asymmetrical activation of the left wing spoiler due to a broken retraction cable during takeoff. A factor associated with the incident was the operator's inadequate inspection of the cable.NTSB MIA02FA045Accident · 4 fatalField investigationFinal reportPiper PA-32-260 · Jacksonville, FLThe pilot becoming spatially disoriented and losing control of the airplane during a missed approach resulting in the airplane descending uncontrolled and colliding with trees and the ground.NTSB MIA02FA044Accident · 3 fatalField investigationFinal reportPiper PA-46-350P · Raleigh, NCthe pilot's failure to maintain control of the airplane, due to spatial disorientation, while performing a missed approach, resulting in an uncontrolled descent, and subsequent impact with a tree and a house. Factors in this accident were dark night, fog,…NTSB FTW02LA053Accident · Serious injuriesLimited investigationFinal reportRyan Navion A · Sierra Blanca, TXthe pilot's inadverent VFR flight into instrument meteorological weather conditions which resulted in an in-flight collision with terrain. Contributing factors were the night light conditions and the clouds.NTSB FTW02LA052Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Duncan, OKThe pilot's descent below the minimum descent altitude, and his failure to maintain obstacle clearance. Contributing factors were the below approach/landing minimum weather, the dark night conditions, and the inoperative REIL's.NTSB DEN02LA014Accident · No injuriesLimited investigationFinal reportCessna 172N · Broomfield, COthe pilot's failure to maintain directional control of the airplane while landing. A contributing factor was the crosswind.NTSB CHI02IA050Incident · No injuriesIncident investigationFinal reportBoeing 737-322 · Chicago, ILReason for occurrence is undetermined.NTSB CHI02FA049Accident · 1 fatalField investigationFinal reportRobinson R44 · Waukesha, WIThe pilot's continued flight into adverse weather and not maintaining altitude/clearance from the static line during cruise flight. Factors were the static wire, the darkness of night, the low ceiling, and the vehicle.NTSB ATL02FA017Accident · 3 fatalField investigationFinal reportBeech BE-55 · Montgomery, ALThe pilots failure to maintain airspeed while maneuvering in instrument flight conditions resulting in an inadvertence stall/spin (vertical descent) and subsequent in-flight collision with trees and terrain.NTSB WAS02WA011Accident · 1 fatalForeign investigationRobinson R22 · Phitippeburg, GermanyNTSB SEA02LA037Accident · 2 fatalLimited investigationFinal reportMooney M20C · Netarts, ORReason for occurrence undetermined.NTSB NYC02WA037Accident · Minor injuriesForeign investigationSchweizer 300C · Stockerau, AustriaNTSB LAX02LA046Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · La Verne, CAThe pilot's failure to maintain directional control following his misjudged landing flare and hard touchdown.NTSB FTW02TA051Accident · No injuriesFinal reportCessna T210K · San Antonio, TXthe failure of the right main landing gear downlock mechanism to engage for reasons undetermined.NTSB FTW02FA048Accident · 2 fatalField investigationFinal reportGates Learjet 24D · Sierra Blanca, TXloss of control during descent for undetermined reasons.NTSB SEA02LA020Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Halfway, ORA loss of aircraft control for undetermined reasons. A factor was a snow-covered landing surface.NTSB NYC02LA036Accident · No injuriesLimited investigationFinal reportRockwell NA-265-80 · Boston, MAThe failure of the left thrust reverser assembly due to fatigue.NTSB LAX02RA045Accident · 1 fatalForeign investigationBeech 200C · Mount Gambier, AustraliaNTSB LAX02LA044Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Honolulu, HIFuel exhaustion due to the pilot's inadequate preflight inspection and improper in-flight decision and planning.NTSB CHI02FAMS1Accident · 4 fatalMissing aircraftFinal reportCessna R182 · Lake Michigan, ILThe uncontrolled descent for undetermined reasons.NTSB LAX02LA043Accident · 1 fatalLimited investigationFinal reportRominger Zic Zac Bird · Marina, CAthe failure the right wing spar and the subsequent separation of the right wing. Contributing factors were the pilot's inadequate maintenance, and the weakened wing structure due to a preexisting fuel tank leak.NTSB FTW02LA050Accident · Serious injuriesLimited investigationFinal reportHeard RV-6A · Comfort, TXthe pilot's inadequate recovery from a bounced landing, which resulted in a hard landing and collapse of the nose landing gear.NTSB FTW02FA054Accident · 2 fatalField investigationFinal reportCessna T210-M · Monticello, ARThe separation of the #2 connecting rod and subsequent catastrophic failure of the engine. A factor was the in-flight collision with a vehicle while maneuvering to a emergency landing area.NTSB CHI02LA053Accident · No injuriesLimited investigationFinal reportCessna 172L · Reedsburg, WIThe pilot inadvertently released the seat adjustment mechanism which resulted in the seat sliding back during takeoff, and his subsequent failure to maintain control of the airplane. A factor associated with the accident was the runway light control box,…NTSB CHI02LA048Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · O'Neill, NEThe inadequate preflight planning by the pilot resulting in the exhaustion of the fuel supply, and the pilot not maintaining directional control during the forced landing. A factor was the unsuitable landing area selected by the pilot, and the ditch.NTSB CHI02LA047Accident · No injuriesLimited investigationFinal reportDassault Falcon 100 · Lawrence, KSThe copilot's failure to maintain aircraft control during the landing. Factors relating to this accident were the copilot's improper in-flight decision not to execute a go-around, the copilot not performing a go-around, the inadequate crew coordination prior…NTSB WAS02WA010Accident · Minor injuriesForeign investigationBoeing Helicopters Div. 369E · Eberebruum, GermanyNTSB NYC02LA035Accident · No injuriesLimited investigationFinal reportCessna 172M · Ravenna, OHThe student pilot's failure to maintain directional control.NTSB FTW02LA056Accident · No injuriesLimited investigationFinal reportBeech BE-90-E90 · Santa Rosa, NMThe pilot's inadvertent retraction of the landing gear during the landing roll which resulting in the collapse of all 3 landing gears.NTSB FTW02LA047Accident · No injuriesLimited investigationFinal reportCurtiss-Wright SB2C-5 · New Orleans, LAthe Helldiver pilot's failure to maintain visual separation with the Cessna while taxiing. Contributing factors were the Cessna pilot's failure to comply with the local controller's instructions to continue taxiing and the failure of the local and ground…NTSB MIA02LA042Accident · 1 fatalLimited investigationFinal reportFerguson A 26 Vulcan SS · Newnan, GAThe pilot's failure to maintain directional control during landing and go-around, resulting in a collision with a runway perimeter fence pole and trees.NTSB MIA02FA041Accident · Minor injuriesField investigationFinal reportConvair Div. of Gen. Dynamics 340-580STC · Sunny Isles Bch, FLThe inadequate dispatch of the airplane by company personnel prior to the first leg of the flight due to failure of company personnel to prepare a new flight release and weight and balance after considerable time on the ground with the engines operating. Also…NTSB LAX02LA042Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G102 Club Astir Iiib · Banning, CAOn final approach, the pilot's failure to maintain adequate aircraft airspeed and control during an encounter with the gusting high wind.NTSB IAD02LA019Accident · Minor injuriesLimited investigationFinal reportPiper J3 · Livermore Falls, METhe pilot's failure to maintain proper altitude clearance while landing, which resulted in a collision with trees. A factor was the crosswind.NTSB FTW02LA055Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Haltom City, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB SEA02LA019Accident · No injuriesLimited investigationFinal reportCessna 310 · Sidney, MTThe pilot's improper abort procedure and inadequate remedial action, leading to a loss of directional control after losing power in one engine during the takeoff roll. Factors include the loss of power from one engine, and a fence around the perimeter of the…NTSB NYC02LA034Accident · Serious injuriesLimited investigationFinal reportGillette Baby Ace · Spencerport, NYThe pilot's failure to maintain aircraft control during approach to the airport, which resulted in an inadvertent stall.NTSB LAX02FA041Accident · 2 fatalField investigationFinal reportCessna 182E · Prescott, AZthe pilot's failure to adequately deice the airplane prior to takeoff, which resulted in the airplane's degraded aerodynamic and climb performance capability, failure to maintain an adequate airspeed, and a stall/spin. Contributing factors were the pilot's…NTSB LAX02FA040Accident · No injuriesField investigationFinal reportCessna 172C · Corona, CAa loss of engine power due to the pilot's improper use of the carburetor heat controls while in weather conditions conducive to serious carburetor icing.NTSB CHI02LA046Accident · No injuriesLimited investigationFinal reportMiller Lancair 235 · Tecumseh, MIThe pilot's failure to maintain aircraft control during the takeoff. Factors relating to the accident were the crosswind and the wind gusts.NTSB MIA02FA039Accident · 1 fatalField investigationFinal reportBeech BE-55-T42A · Johnson City, TNThe pilot's failure to maintain altitude clearance above the tree resulting in a collision with the tree, subsequent collision with a building, and the ground.NTSB LAX02LA039Accident · No injuriesLimited investigationFinal reportBell 206 B-2 · Aieia, HIThe pilot's loss of lateral control while in a hover that resulted in a rollover and collision with the ground. A factor was the unclear exit and boarding procedures provided to the work crew, who were non-aviators, during the preflight briefing.NTSB DCA02WA012Incident · No injuriesForeign investigationBoeing 767-323 · London, United KingdomNTSB ATL02LA016Accident · Minor injuriesLimited investigationFinal reportWhitty, Philip J. Mustang II · Hampstead, NCA loss of engine power for undetermined reasons, which resulted in a forced landing and subsequent nose over during landing roll. A factor was the soft, unsuitable terrain.NTSB LAX02FA038Accident · 4 fatalField investigationFinal reportPiper PA-24-250 · El Dorado, CAthe pilot's intentional flight into adverse weather conditions and his subsequent failure to maintain aircraft control.NTSB CHI02LA045Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Devils Lake, NDThe student pilot's failure to maintain directional control of the airplane during the takeoff phase of a touch and go landing. Factors associated with the accident were the student's lack of total experience and the runway light which the airplane contacted.NTSB LAX02LA037Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Long Beach, CAthe loss of aircraft control while maneuvering for undetermined reasons.