Final NTSB investigations, 2001

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
  WHERE year(c.\"eventDate\") = 2001
    AND c.\"completionStatus\" = 'Completed'
  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.

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.Dec 13, 2001 · N7701J · DestroyedNTSB 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,…Dec 13, 2001 · N41003 · DestroyedNTSB 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.Dec 13, 2001 · N4530K · Substantial damageNTSB 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.Dec 13, 2001 · N127CA · Substantial damageNTSB 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.Dec 13, 2001 · N73892 · Substantial damageNTSB CHI02IA050Incident · No injuriesIncident investigationFinal reportBoeing 737-322 · Chicago, ILReason for occurrence is undetermined.Dec 13, 2001 · N359UA · No damageNTSB 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.Dec 13, 2001 · N7007F · DestroyedNTSB 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.Dec 12, 2001 · N99DC · DestroyedNTSB SEA02LA037Accident · 2 fatalLimited investigationFinal reportMooney M20C · Netarts, ORReason for occurrence undetermined.Dec 11, 2001 · N5774Q · DestroyedNTSB 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.Dec 11, 2001 · N7844W · Substantial damageNTSB FTW02TA051Accident · No injuriesFinal reportCessna T210K · San Antonio, TXthe failure of the right main landing gear downlock mechanism to engage for reasons undetermined.Dec 11, 2001 · N8299M · Substantial damageNTSB FTW02FA048Accident · 2 fatalField investigationFinal reportGates Learjet 24D · Sierra Blanca, TXloss of control during descent for undetermined reasons.Dec 11, 2001 · N997TD · DestroyedNTSB 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.Dec 10, 2001 · N61385 · Substantial damageNTSB NYC02LA036Accident · No injuriesLimited investigationFinal reportRockwell NA-265-80 · Boston, MAThe failure of the left thrust reverser assembly due to fatigue.Dec 10, 2001 · N819GY · Substantial damageNTSB LAX02LA044Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Honolulu, HIFuel exhaustion due to the pilot's inadequate preflight inspection and improper in-flight decision and planning.Dec 10, 2001 · N6136G · Substantial damageNTSB CHI02FAMS1Accident · 4 fatalMissing aircraftFinal reportCessna R182 · Lake Michigan, ILThe uncontrolled descent for undetermined reasons.Dec 10, 2001 · N2359C · DestroyedNTSB 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.Dec 9, 2001 · N204ED · DestroyedNTSB 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.Dec 9, 2001 · N61AZ · Substantial damageNTSB 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.Dec 9, 2001 · N317RG · DestroyedNTSB 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,…Dec 9, 2001 · N4303Q · Substantial damageNTSB 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.Dec 9, 2001 · N2492K · Substantial damageNTSB 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…Dec 9, 2001 · N202DN · Substantial damageNTSB NYC02LA035Accident · No injuriesLimited investigationFinal reportCessna 172M · Ravenna, OHThe student pilot's failure to maintain directional control.Dec 8, 2001 · N12521 · Substantial damageNTSB 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.Dec 8, 2001 · N5NM · Substantial damageNTSB 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…Dec 8, 2001 · N92879 · 2 aircraft · Minor damageNTSB 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.Dec 7, 2001 · N6129F · Substantial damageNTSB 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…Dec 7, 2001 · N582HG · Substantial damageNTSB 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.Dec 7, 2001 · N102FC · Substantial damageNTSB 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.Dec 7, 2001 · N40621 · Substantial damageNTSB 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.Dec 7, 2001 · N1212B · Substantial damageNTSB 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…Dec 6, 2001 · N5043J · Substantial damageNTSB 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.Dec 5, 2001 · N916MG · Substantial damageNTSB 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…Dec 5, 2001 · N3049Y · DestroyedNTSB 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.Dec 5, 2001 · N1834Y · Substantial damageNTSB 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.Dec 5, 2001 · N417EM · Substantial damageNTSB 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.Dec 4, 2001 · N50KF · DestroyedNTSB 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.Dec 4, 2001 · N968YC · Substantial damageNTSB 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.Dec 4, 2001 · N888PW · Substantial damageNTSB 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.Dec 3, 2001 · N6946P · DestroyedNTSB 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.Dec 3, 2001 · N248ND · Substantial damageNTSB LAX02LA037Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Long Beach, CAthe loss of aircraft control while maneuvering for undetermined reasons.Dec 2, 2001 · N50554 · DestroyedNTSB LAX02LA036Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Prescott, AZFuel starvation on final approach due to the pilot's fuel mismanagement, and his inattentiveness in following established prelanding procedures.Dec 2, 2001 · N7213P · Substantial damageNTSB MIA02LA038Accident · No injuriesLimited investigationFinal reportByrd KR-2S · Linden, NCThe pilot's failure to correct a condition where visual contact with the terrain was lost due to sunshine glare, resulting in collision with a tree during final approach for landing.Dec 1, 2001 · N366KR · DestroyedNTSB MIA02FA037Accident · 2 fatalField investigationFinal reportCessna 208B · Bessemer, ALThe poor in-flight planning by the pilot-in-command for his initiation of the ILS approach to runway 05 with weather conditions below minimums for the approach contrary to the federal aviation regulations, and the failure of the pilot to maintain control of…Dec 1, 2001 · N499BA · DestroyedNTSB LAX02LA035Accident · No injuriesLimited investigationFinal reportClassic Waco YMF · Banning, CAa loss of engine power due to a crack in the carburetor float and leaking portions of the carburetor that resulted in an overly rich mixture.Dec 1, 2001 · N31BN · Substantial damageNTSB FTW02LA044Accident · No injuriesLimited investigationFinal reportBell 47G · Ardmore, OKthe flight instructor's selection of an unsuitable area for practicing a full touchdown autorotation, which resulted in a nose over. A contributing factor was the soft ground.Dec 1, 2001 · N5226 · Substantial damageNTSB DEN02LA013Accident · Serious injuriesLimited investigationFinal reportBell 206B · Bryce, UTloss of engine power for reasons undetermined. Contributing factors were the low airspeed and altitude at which to perform an autorotation.Dec 1, 2001 · N911KH · Substantial damageNTSB LAX02LA034Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401B · Las Vegas, NVthe failure of the AT-401 pilot to maintain clearance with the AT-402 airplane during landing. Contributing factors were the unreliable communication radio in the AT-401, the AT-401 pilot's continued flight with known communication radio problems, and the…Nov 30, 2001 · N9186J · 2 aircraft · No damageNTSB FTW02LA046Accident · No injuriesLimited investigationFinal reportCessna 152 · Perry, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.Nov 30, 2001 · N95565 · Substantial damageNTSB CHI02LA044Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-40 · St Paul, MNThe autopilot's computer connections arcing and reported disconnection during the localizer approach and the pilot not performing a go around prior to the hard landing. A factor was the pilots lack of total experience in the accident airplane's make and model.Nov 30, 2001 · N9052Y · Substantial damage