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 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.Nov 6, 2001 · N108MS · Substantial damageNTSB 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…Nov 5, 2001 · N8347T · Substantial damageNTSB 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.Nov 5, 2001 · N7197Y · DestroyedNTSB CHI02LA038Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Hawley, MNthe failure of the pilot to maintain directional control. A factor was the trees.Nov 5, 2001 · N256J · Substantial damageNTSB CHI02LA032Accident · No injuriesLimited investigationFinal reportPiper PA-15 · Decatur, ILThe excessive braking performed by the flight instructor.Nov 5, 2001 · N4576H · Substantial damageNTSB CHI02LA021Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Lambertville, MIThe pilot's improper flare during landing.Nov 5, 2001 · N888BD · Substantial damageNTSB LAX02LA022Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Avalon, CAthe total loss of engine power during departure climb for undetermined reasons.Nov 4, 2001 · N3516W · Substantial damageNTSB 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.Nov 4, 2001 · N1147B · Substantial damageNTSB 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.Nov 4, 2001 · N4447D · Substantial damageNTSB 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.Nov 4, 2001 · N82813 · Substantial damageNTSB 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.Nov 3, 2001 · N5511G · Substantial damageNTSB 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…Nov 3, 2001 · N5207Z · Substantial damageNTSB 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.Nov 3, 2001 · N19KH · Substantial damageNTSB 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.Nov 3, 2001 · N96LS · Substantial damageNTSB FTW02FA028Accident · 1 fatalField investigationFinal reportRobinson R22 · Seagoville, TXthe flight instructor's failure to maintain clearance with wires while maneuvering along a river.Nov 3, 2001 · N127RB · Substantial damageNTSB 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.Nov 3, 2001 · N117JB · Substantial damageNTSB 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.Nov 3, 2001 · N43334 · DestroyedNTSB 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.Nov 2, 2001 · N26WF · Substantial damageNTSB NYC02LA024Accident · No injuriesLimited investigationFinal reportCessna 172D · Argyle, NYThe pilot's failure to maintain aircraft control while maneuvering.Nov 2, 2001 · N36SK · Substantial damageNTSB 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.Nov 2, 2001 · N210CJ · Substantial damageNTSB 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.Nov 2, 2001 · N814AW · No damageNTSB 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.Nov 2, 2001 · N5984V · Substantial damageNTSB 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.Nov 1, 2001 · N7270E · DestroyedNTSB NYC02LA022Accident · No injuriesLimited investigationFinal reportMooney M20S · Buckhannon, WVThe CFI's improper flare, which resulted in a hard landing.Oct 31, 2001 · N1008R · Substantial damageNTSB CHI02LA017Accident · No injuriesLimited investigationFinal reportLuscombe LL-8-E · Bellaire, MIthe unsuitable terrain for landing selected by the pilot. A factor was the soft terrain.Oct 31, 2001 · N1243K · Substantial damageNTSB 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.Oct 31, 2001 · N93550 · Substantial damageNTSB 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.Oct 30, 2001 · N90688 · Substantial damageNTSB NYC02LA019Accident · 2 fatalLimited investigationFinal reportNorton/Cloeren Titan Tornado II · New Windsor, MDLoss of power for an undetermined reason.Oct 30, 2001 · N996T · DestroyedNTSB LAX02FA018Accident · 1 fatalField investigationFinal reportCessna P210N · Mt. Charleston, NVthe pilot's failure to maintain an adequate airspeed after continuing flight into forecast adverse meteorological conditions consisting of turbulence, icing, and downdrafts, which resulted in a stall/spin.Oct 30, 2001 · N734VM · DestroyedNTSB IAD02LA007Accident · Serious injuriesLimited investigationFinal reportBoeing 757-223 · Dulles, VAA passenger sustained a broken ankle during an emergency evacuation.Oct 30, 2001 · N640A · No damageNTSB FTW02LA026Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta II · Redrock, NMThe pilot's failure to maintain clearance with terrain. Contributing factors were the mountainous terrain and high density altitude.Oct 30, 2001 · N8373T · Substantial damageNTSB CHI02LA016Accident · No injuriesLimited investigationFinal reportCessna T210M · Salem, ILThe ruptured hydraulic hose.Oct 30, 2001 · N761UV · Substantial damageNTSB ANC02LA004Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Port Heiden, AKThe pilot's delay in aborting the landing. Factors in the accident were snow and ice on the runway surface, and the pilot's excessive taxi speed.Oct 30, 2001 · N5573J · DestroyedNTSB LAX02LA017Accident · No injuriesLimited investigationFinal reportCessna 172M · Prescott, AZThe CFI's improper remedial action and failure to maintain directional control during landing in a strong crosswind condition.Oct 29, 2001 · N13514 · Substantial damageNTSB NYC02LA018Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Batavia, OHMalfunction of an exhaust valve. A factor was the pilot/owner's failure to comply with the engine manufacturer's service instructions.Oct 28, 2001 · N5664L · Substantial damageNTSB MIA02LA014Accident · 2 fatalLimited investigationFinal reportRans S-6 · Wyatte, MSthe failure of the pilot to maintain airspeed, which resulted in an inadvertent stall/spin, and subsequent impact with trees, while at a low altitude.Oct 28, 2001 · N1173R · DestroyedNTSB MIA02LA013Accident · Serious injuriesLimited investigationFinal reportBeech C23 · Athens, GAthe pilot misjudged the ailment of the airplane on the active runway, inadvertently taking off from a parallel taxiway, and subsequently departing the hard surface into a 40 foot drop off. A factor in this accident was a dark night, and the pilot's total…Oct 28, 2001 · N24697 · Substantial damageNTSB FTW02LA025Accident · Serious injuriesLimited investigationFinal reportCameron Balloon A-210 · Albuquerque, NMthe pilot's excessive descent rate during the landing approach, which resulted in a hard landing. Contributing factors were the high wind conditions and the lack of suitable terrain for the landing.Oct 28, 2001 · N30606 · Minor damageNTSB FTW02LA023Accident · Minor injuriesLimited investigationFinal reportPiper PA28-140 · Wilton, ARthe pilot's failure to obtain a proper touchdown point and his excessive approach speed during a forced landing. A contributing factor was the total loss of engine power for undetermined reasons.Oct 28, 2001 · N8305R · Substantial damageNTSB DEN02FA004Accident · 1 fatalField investigationFinal reportCessna T337G · Palmer Lake, COthe pilot intentionally restricting his external vision (turning his cabin lights up bright to practice night instrument approaches), and his subsequent failure to maintain clearance of the mountain. A contributing factor was the Air Traffic Controller’s…Oct 28, 2001 · N45E · DestroyedNTSB CHI02LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Lapeer, MIthe touchdown aim point not attained by the pilot rated student and the remedial action not performed by the flight instructor.Oct 28, 2001 · N6899C · Substantial damageNTSB CHI02LA014Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Fort Wayne, INThe pilot not maintaining control of the airplane during an attempted go-around. A factor was the trees.Oct 28, 2001 · N4879L · DestroyedNTSB LAX02LA015Accident · No injuriesLimited investigationFinal reportThomson Harmon Rocket II · Perris, CAthe airplane builder's failure to properly install a bolt and nut into the aileron and elevator flight control system. A contributing factor was the soft terrain conditions for the ensuing forced landing.Oct 27, 2001 · N325L · Substantial damageNTSB FTW02LA024Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Giddings, TXThe failure of the Cessna pilot to maintain directional control while landing, which resulted in a collision with the Lake.Oct 27, 2001 · N4127G · 2 aircraft · Substantial damageNTSB FTW02LA022Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Clarendon, TXthe loss of engine power for undetermined reasons. Contributing factors to the accident were the dark night light conditions and the lack of suitable terrain for the forced landing.Oct 27, 2001 · N614CJ · Substantial damageNTSB CHI02LA013Accident · Serious injuriesLimited investigationFinal reportMeester HP-14 · Sturtevant, WIThe restricted movement of the aileron control system for undetermined reasons.Oct 27, 2001 · N8833 · Substantial damageNTSB NYC02LA017Accident · Minor injuriesLimited investigationFinal reportBeech B95A · Pittstown, NJThe pilot’s failure to maintain adequate airspeed during a go-around in gusty wind conditions, which resulted in an inadvertent stall. A factor was the gusty wind conditions.Oct 26, 2001 · N919Q · Substantial damageNTSB FTW02LA074Accident · No injuriesLimited investigationFinal reportBeech 58 · Farmington, NMThe failure of the nose gear actuator retract arm due to fatigue.Oct 26, 2001 · N8117V · Substantial damageNTSB FTW02LA021Accident · No injuriesLimited investigationFinal reportCessna 152 · Bethany, OKthe mechanic's failure to properly lock the exhaust valve's clearance adjusting screw locknut, which resulted in a loose nut, disabling of the exhaust valve pushrod, and a partial loss of engine power while in cruise flight. A contributing factor was the…Oct 26, 2001 · N67797 · Substantial damageNTSB DEN02LA005Accident · No injuriesLimited investigationFinal reportIrwin Thorp T-18 · Longmont, COThe loss of engine power for undetermined reasons, which resulted in a forced landing. A contributing factor was the lack of suitable terrain for the forced landingOct 26, 2001 · N2819L · Substantial damage