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 ATL01LA034Accident · Serious injuriesLimited investigationFinal reportJack McDaniel Rans S-12 · Homestead, FLThe pilots failure to maintain flying speed during a soft field takeoff, that resulted in the loss of control and a stall/ spin.NTSB NYC01LA078Accident · No injuriesLimited investigationFinal reportCessna 172P · Miamisburg, OHThe pilot's failure to attain the proper touchdown point. Factors included the nighttime conditions, and the pilot's improper decision to leave the runway lighting at high intensity.NTSB MIA01FA074Accident · Minor injuriesField investigationFinal reportAmerican 8KCAB · Leesburg, FLThe failure of the pilot of N123WA and the failure of both pilots of N301NL to adequately insure visual separation between their aircraft and other aircraft in the landing pattern, resulting in a runway collision. Factors contributing to the accident were the…NTSB LAX01LA095Accident · No injuriesLimited investigationFinal reportBeech A36 · Palo Alto, CAThe pilot-in-command's delayed decision to go-around and his failure to maintain sufficient airspeed during the attempted go-around. His non-verification of the flap setting contributed to the accident.NTSB LAX01LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · San Diego, CAFuel starvation due to the pilot inadvertently shutting off its supply on approach for landing.NTSB CHI01FA083Accident · 2 fatalField investigationFinal reportSwearingen SA227-AT · Beaver Island, MIThe flightcrew not maintaining altitude/clearance during the circling instrument approach. Factors were the pilot in command initiating the flight without proper weather reporting facilities at the destination, the flightcrew not flying to an alternate…NTSB WAS01RA001Accident · 3 fatalForeign investigationGates Learjet 35A · Nurnberg, GermanyNTSB SEA01LA047Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Bozeman, MTThe pilot rated passenger's failure to maintain directional control during the landing. A factor was the snow berm which the aircraft rolled into during the landing.NTSB MIA01FA072Accident · 1 fatalField investigationFinal reportPiper PA-30 · Ponce, PRThe pilot's decision to attempt flight with known deficiencies in the airplanes right engine, his failure to feather the right propeller after the engine failed , his failure to retract the landing gear following the engine failure, and his failure to…NTSB FTW01LA060Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Bishop, TXthe pilot's failure to maintain altitude and clearance from terrain. Contributing factors were the pilot's diverted attention and the low ceiling.NTSB CHI01LA082Accident · Serious injuriesLimited investigationFinal reportBeech 65-B80 · Sioux Falls, SDThe pilot initiated the flight into known icing conditions which resulted in his ability to maintain control of the airplane. Factors associated with the accident were the ice accumulation and the company induced pressure for the pilot to make the flight into…NTSB ATL01LA033Accident · Minor injuriesLimited investigationFinal reportCessna 210M · Augusta, GAThe pilot's failure to properly preflight fuel required for the flight that resulted in fuel exhaustion and the lost of engine power.NTSB SEA01LA046Accident · 1 fatalLimited investigationFinal reportWestern International UH-1H · Darby, MTInflight loss of a tail rotor pitch change link-to-blade grip attach bolt, resulting partial loss of tail rotor control, and subsequent entanglement of the helicopter's external load cable with a tree during emergency descent. Factors included the pilot's…NTSB LAX01LA093Accident · No injuriesLimited investigationFinal reportBell 47G-5 · Pixley, CAA loss of control during takeoff due to the helicopter's heavy gross weight condition that exceeded its lifting capability.NTSB FTW01IA062Incident · No injuriesIncident investigationFinal reportCessna 172S · Ruston, LAthe loss of engine power while manuevering as a result of an incorrect mixture control adjustment. A contributing factor was the lack of suitable terrain for the ensuing forced landing.NTSB DEN01LA050Accident · No injuriesLimited investigationFinal reportDassault-Breguet Mystere Falcon 900 · Pinedale, WY**This report was modified on 2/18/2016. Refer to the public docket for this accident for an explanation of the changes.** loss of directional control after touchdown for undetermined reasons.NTSB CHI01LA086Accident · No injuriesLimited investigationFinal reportCessna 310Q · Mitchell, SDThe pilot disregarded the aircraft limitation placard, and attempted flight into known adverse weather after receiving a hazardous weather advisory. Factors to the accident were the ice-covered cockpit windshield, the ice-covered runway, and the snowbank.NTSB CHI01FA080Accident · 1 fatalField investigationFinal reportBeech 58 · Ainsworth, NEthe pilot's improper in-flight decision to continue flight into known adverse weather. A factor was the icing conditions.NTSB SEA01WA048Accident · No injuriesForeign investigationHughes 369D · Boudaya, IYNTSB NYC01LA077Accident · No injuriesLimited investigationFinal reportFokker F28 MK 0100 · Boston, MAthe failure of the flight crew to follow the checklist prior to engine start, and their subsequent diverted attention during engine start.NTSB MIA01LA073Accident · No injuriesLimited investigationFinal reportCessna A150K · Cabo Rojo, PRThe failure of the pilot to use carburetor heat during descent resulting in loss of engine power due to carburetor icing and the airplane colliding with a fence and nosing over during a forced landing.NTSB IAD01LA033Accident · No injuriesLimited investigationFinal reportMooney M20C · Peckville, PAloss of engine power for undetermined reasons.NTSB FTW01FA058Accident · 2 fatalField investigationFinal reportCessna 152 · Platter, OKthe failure of both pilots to maintain a visual lookout, which resulted in a mid-air collision over a lake. A contributing factor to the accident was the sun glare from the setting sun.NTSB ATL01LA031Accident · Serious injuriesLimited investigationFinal reportSorrell SNS-2 Guppy · Raymond, MSThe failure of the rudder horn bracket, that resulted in the inflight loss of control.NTSB ANC01LA036Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Anvik, AKThe pilot's continued VFR flight into instrument meteorological conditions, and subsequent in-flight collision with terrain during descent. Factors in the accident were the presence of fog, and snow-covered terrain.NTSB LAX01LA088Accident · No injuriesLimited investigationFinal reportFish RV6 · Georgetown, CAThe total loss of engine power due to fracture and separation of the engine crankshaft.NTSB DEN01LA048Accident · Serious injuriesLimited investigationFinal reportCessna 182L · Canon City, COThe loss of engine power during takeoff initial climb resulting from an excessively rich fuel/air mixture, which fouled the spark plugs. A factor was rough, unsuitable terrain for a forced landing.NTSB MIA01FA071Accident · 2 fatalField investigationFinal reportMooney M20R · Bluffton, SCThe pilot's failure to maintain control due to spatial disorientation.NTSB LAX01LA087Accident · 2 fatalLimited investigationFinal reportSutton Tailwind W-8L · Reno, NVThe pilot performed aerobatics at low altitude and failed to maintain clearance from the gound resulting in a collision with the terrain.NTSB LAX01LA086Accident · Minor injuriesLimited investigationFinal reportStorey MK 7 · Marana, AZThe pilot's inadequate preflight preparation with regards to runway choice, terrain, and performance capabilities of the airplane.NTSB DEN01LA049Accident · No injuriesLimited investigationFinal reportCessna 180K · Clovis, NMThe pilot's failure to maintain directional control, which resulted in the subsequent swerve of the airplane. Contributing factors were the pilot's lack of experience in make and model and his diverted attention while attempting to adjust the trim.NTSB DEN01LA047Accident · No injuriesLimited investigationFinal reportBeech V-35A · Albuquerque, NMthe pilot's inattention during night taxiing, which resulted in his airplane impacting a parked airplane.NTSB DCA01WA020Incident · No injuriesForeign investigationBoeing 747-300 · Point A Pitre, GuadeloupeNTSB CHI01FA077Accident · 2 fatalField investigationFinal reportWatson Steen Skybolt · Camdenton, MOThe pilot not maintaining altitude/clearance from terrain during the low altitude maneuver. Factors were the wind gusts and the low altitude maneuver the pilot performed.NTSB ATL01LA030Accident · No injuriesLimited investigationFinal reportLearjet 25B · Ft. Pierce, FLThe mechanic's failure to properly install and secure the left main landing gear aft trunnion pin in accordance with procedures.NTSB ANC01TA035Accident · No injuriesFinal reportRobinson R-44 · Chickaloon, AKThe pilot's collision with terrain due to his inadequate planning of the approach, and his failure to maintain the helicopter's main rotor RPM during a go-around. Factors in the accident were a tailwind, flat lighting conditions, and snow-covered terrain.NTSB SEA01LA045Accident · No injuriesLimited investigationFinal reportAlexander MA-5 Charger · Spanaway, WAthe pilot's failure to apply carburetor heat prior to takeoff while operating in serious carburetor icing conditions. Factors include operating in serious carburetor icing conditions, and rough/uneven terrain in the area of the forced landing.NTSB NYC01LA075Accident · No injuriesLimited investigationFinal reportBoeing B-737-832 · Boston, MAThe inadequate visual lookout by theMD-81's tug driver during the pushback operation.NTSB LAX01LA091Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Lake Elsinore, CAThe failure of the glider pilot to maintain adequate airspeed during a turn from base leg to final approach, which lead to a stall and spin.NTSB LAX01LA090Accident · Minor injuriesLimited investigationFinal reportLuscombe 8F · Tombstone, AZThe pilot's lack of directional control on the landing roll, which resulted in a ground loop and inadvertent nose over.NTSB LAX01LA085Accident · No injuriesLimited investigationFinal reportCessna T210M · Kelseyville, CAThe failure of the pilot to comply with emergency procedures contained in the Pilot's Operating Handbook, which resulted in an excessively rich mixture and loss of engine power.NTSB IAD01LA031Accident · No injuriesLimited investigationFinal reportEnstrom F28A · Napoleon, OHThe fatigue failure in the fillet radius of the mast, which resulted in the separation of the main rotor system.NTSB FTW01LA067Accident · No injuriesLimited investigationFinal reportBritish Aerospace HS.125-700A · New Orleans, LAthe pilot-in-command's inadequate preflight inspection, which resulted in a flight with a blocked fuel tank vent. A contributing factor was maintenance personnel's failure to remove the tape covering the fuel tank vent following a pressure test.NTSB CHI01LA081Accident · No injuriesLimited investigationFinal reportCessna 172RG · Troy, MIthe excessive touchdown airspeed and the directional control not maintained by the pilot. The snow bank was a contributing factor.NTSB ATL01LA029Accident · Minor injuriesLimited investigationFinal reportRobert D. Wood Velocity Xlfg · Sebastian, FLThe manufacturer's inadequate design of the winglet/rudder assembly, and inadequate bonding techniques for metal to fiber structures, which resulted in control surface flutter.NTSB MIA01GA070Accident · 2 fatalFinal reportPiper PA-32-300 · Marathon, FLThe pilot-in-command's lack of recent experience in instrument flight resulting in the pilot becoming spatially disoriented, and subsequent in-flight collision with water while descending.NTSB LAX01LA089Accident · Minor injuriesLimited investigationFinal reportArthur Dragonfly · Marana, AZA total loss of engine power for undetermined reasons. Contributing to the accident was the rough/uneven terrain.NTSB CHI01LA079Accident · No injuriesLimited investigationFinal reportCessna 310R · Cahokia, ILThe collapse of the left main landing gear during landing roll for undetermined reasons.NTSB CHI01LA078Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Charlevoix, MIThe pilot failed to maintain directional control of the airplane due to inadequate compensation for the wind conditions. Factors associated with the accident were the gusty crosswind, the icy runway, and the snow bank.NTSB NYC01LA074Accident · No injuriesLimited investigationFinal reportBeech B-19 · Louisa, VAThe pilot's failure to maintain airspeed, which resulted in a hard landing. Factor's in this accident were the loss of electrical power due to an alternator failure and the night light conditions.