NTSB investigations, 2001
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 FTW01LA177Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Bunkie, LAThe loss of engine power for undetermined reasons while maneuvering. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN01LA142Accident · No injuriesLimited investigationFinal reportPiper PA-60-602P · Rock Springs, WYthe right main tire blowing out in flight, which resulted in a loss of directional control during landing.NTSB CHI01LA272Accident · No injuriesLimited investigationFinal reportCessna 152 · Peru, ILThe pilot's inadequate recovery from a bounced landing. Factors associated with the accident were improper touchdown point, rough terrain, and the nose gear collapse.NTSB CHI01LA269Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Mackinac Island, MIThe pilot's failure to maintain proper glidepath during the landing approach resulting in the pilot not maintaining clearance from the trees. Factors were the haze, the gusty winds, and the trees.NTSB NYC01LA206Accident · Minor injuriesLimited investigationFinal reportSchweizer 300C · Cicero, NYThe pilot's failure to maintain directional control while hovering, and the CFI's delayed remedial action.NTSB NYC01LA205Accident · Serious injuriesLimited investigationFinal reportRans S-7 · Sydnorsville, VAA loss of engine power due to an engine over-temperature condition, which resulted in a forced landing and subsequent collision with trees.NTSB MIA01WA214Accident · 5 fatalForeign investigationCessna 210 · Barcelonette, FranceNTSB LAX01LA273Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Fullerton, CAloss of engine power due to fuel contamination.NTSB DEN01LA141Accident · No injuriesLimited investigationFinal reportEnstrom 280FX · Ouray, COthe partial loss of engine power due to the slippage of the wastegate linkage as a result of the plunger on the linkage being undertorqued by an unknown person. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ANC01LA110Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Delta Junction, AKThe pilot's failure to maintain directional control during the landing roll. A factor associated with the accident is rough and uneven terrain at the off-airport landing site.NTSB SEA01LA147Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26B · Rock Island, WAThe student pilot's improper inflight planning and decision (delay in establishing an approach to a suitable landing area) and his subsequent failure to attain the proper glidepath for the selected landing area, resulting in an overshoot of the selected…NTSB MIA01LA210Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Fort Lauderdale, FLThe failure of the mechanic who installed the carburetor after overhaul to safety the throttle linkage at the carburetor per an Airworthiness Directive resulting in separation of the throttle linkage and subsequent partial loss of engine power. Contributing…NTSB IAD01LA095Accident · No injuriesLimited investigationFinal reportHughes 269C · Lewiston, NYThe pilot's failure to maintain rotor rpm during the simulated forced landing. Also causal in the accident was the failure of both pilots to recognize the total loss of engine power and the CFI's inadequate remedial actions. A factor in the accident was the…NTSB IAD01LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Odenton, MDImproper maintenance inspections, which resulted in a blocked carburetor.NTSB FTW01LA196Accident · Minor injuriesLimited investigationFinal reportWSK PZL Mielec M-18 · Dumas, ARThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB DEN01LA139Accident · Serious injuriesLimited investigationFinal reportCessna 320 · Falcon, COthe pilot's failure to abort the takeoff following a loss of right engine power. A factor was the loss of right engine power for undetermined reasons.NTSB ANC01LA111Accident · No injuriesLimited investigationFinal reportCessna 180A · Arctic Village, AKThe pilot's improper use of carburetor heat during a go-around. Factors in the accident were carburetor icing conditions, and high vegetation in the landing area.NTSB LAX01FA271Accident · Serious injuriesField investigationFinal reportCessna 336 · Palmdale, CAThe pilot's inadequate preflight inspection of the primer controls, resulting in excessive fuel flow, spark plug fouling, and loss of engine power in the aft engine.NTSB FTW01LA201Accident · No injuriesLimited investigationFinal reportCessna 182L · Porter, TXthe pilot's improper recovery from a bounced landing.NTSB CHI01LA267Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Racine, WIThe total loss of engine power during cruise flight due to the number 3 cylinder thru-studs fatigue fractures, and the thru-stud's low hardness as a result improper heat treatment of the thru-studs, and the unsuitable terrain encountered during the forced…NTSB CHI01LA264Accident · Minor injuriesLimited investigationFinal reportBeech 23 · West Bend, WIThe pilot not following the aircraft fuel management procedures. Factors were the fuel starvation, the low altitude, the manufacturers service instruction not complied with, and the tree.NTSB CHI01LA262Accident · No injuriesLimited investigationFinal reportGrice Avid Flyer · Belle Fourche, SDThe pilot failed to maintain aircraft control during the forced landing. A factor associated with the accident was the excessive adjustment that the pilot made to the propeller's pitch prior to the flight.NTSB ANC01LA116Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anaktuvuk Pass, AKA failure of the landing gear strut assembly due to corrosion. A factor in the accident was the pilot's inadequate maintenance of the airplane.NTSB ANC01FA100Accident · Serious injuriesField investigationFinal reportCessna 172S · Cooper Landing, AKThe pilot's inadequate remedial action to disconnect the autopilot during an uncommanded altitude deviation while in cruise flight. Factors in the accident were activation of the autopilot; the pilot's lack of familiarity with the airplane's autopilot system;…NTSB NYC01LA204Accident · No injuriesLimited investigationFinal reportRobinson R22 · Islip, NYThe flight instructor's delayed remedial action during a practice autorotation. Factors included the flight instructor's overconfidence in the pilot receiving instruction, and that pilot's improper recovery from a practice autorotation.NTSB NYC01FA201Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Sedgwick, METhe failure of the pilot to maintain control while maneuvering.NTSB LAX01FA270Accident · 1 fatalField investigationFinal reportBeech B36TC · Weaverville, CAthe pilot's selection of the wrong runway, which resulted in an attempted takeoff uphill in a prevailing tailwind toward rising terrain and high obstacles. Also causal was the pilot's loading of the airplane above maximum gross weight and his failure to…NTSB IAD01LA092Accident · Serious injuriesLimited investigationFinal reportAerotek Pitts S2 · Xenia, OHThe airplane's excessive airspeed during the approach, which resulted in the pilot's failure to maintain directional control during landing.NTSB FTW01LA174Accident · No injuriesLimited investigationFinal reportCessna 152 · Denison, TXthe pilot's delay in aborting the takeoff, which resulted in a runway overrun.NTSB FTW01LA172Accident · Serious injuriesLimited investigationFinal reportBell 206-L1 · Wc 173the pilot's failure to maintain yaw control of the helicopter during approach.NTSB ENG01RA005Incident · 3 fatalForeign investigationDassault Falcon 20 · Narsarsuaq, GreenlandNTSB DCA01MA056Accident · 1 fatalMajor investigationFinal reportde Havilland Dash 8-100 · Washington, DCThe ramp agent's impaired performance due to his hyperthyroidism, which was exacerbated by the heat and was inadequately controlled by medication, and possibly also due to the use of an antianxiety medication.NTSB CHI01LA266Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Beaver Island, MIThe pilot misjudged the approach and landing, and his failure to abort the landing. Factors associated with the accident were the trees at the approach end of the runway and the sand/gravel pit that the airplane traveled into.NTSB CHI01LA265Accident · No injuriesLimited investigationFinal reportCessna 172M · Milton, WIThe unsuitable terrain for landing encountered by the pilot. Factors were the high vegetation and the loss of engine power for undetermined reasons.NTSB CHI01LA259Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Blooming Prairi, MNThe reported loss of engine power for undetermined reasons during a the cruise portion of a CFR part 137 observation, and the pilot not following the height/velocity charts data.NTSB CHI01LA258Accident · Serious injuriesLimited investigationFinal reportCessna A185F · Crane Lake, MNThe inadvertant control interference by the passenger's knee leading to the pilot's directional control of the floatplane not being possible.NTSB CHI01FA257Accident · 2 fatalField investigationFinal reportSchweizer 269C · Waterloo, INAircraft control not maintained for undetermined reasons.NTSB ANC01LA105Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Talkeetna, AKThe pilot's inadequate compensation for wind conditions. A factor associated with the accident was a crosswind.NTSB SEA01LA146Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Latah, WAthe failure of a cylinder head exhaust rocker shaft boss while the aircraft was performing aerial application. Factors include soft terrain and a drop-off in the field where the emergency landing took place.NTSB NYC01LA203Accident · Serious injuriesLimited investigationFinal reportCessna 172L · Parkersburg, WVThe student pilot's failure to obtain a proper rate of climb, resulting in a collision with trees.NTSB MIA01LA209Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Statesville, NCThe pilot's attempted takeoff with a tail wind and his failure to maintain directional control of the airplane during takeoff resulting in the airplane veering to the left and colliding with trees.NTSB MIA01LA208Accident · No injuriesLimited investigationFinal reportMorton S. Dismuke Spencer Amphib 1-12E · Pensacola, FLThe dragging of the right wing during water operations for undetermined reasons resulting in the airplane flipping inverted.NTSB LAX01LA269Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Fort Bragg, CAthe pilot's failure to maintain airspeed while making a precautionary landing resulting in an inadvertent stall.NTSB LAX01LA268Accident · No injuriesLimited investigationFinal reportWeatherly 620B · Winnemucca, NVthe pilot's failure to maintain clearance with the wires while he was maneuvering for an aerial application run.NTSB IAD01LA091Accident · Serious injuriesLimited investigationFinal reportDelbridge Rotorway Exec 162F · Carrollton, VApilot's inadequate fuel consumption calculations, which resulted in a loss of engine power due to fuel exhaustion.NTSB IAD01IA093Incident · No injuriesIncident investigationFinal reportMorrison Rans S-12 · Midland, VAThe pilot's failure to obtain/maintain the proper descent rate which resulted in a hard landing and separation of the landing gear. A factor in the incident was the pilot's improper decision to participate in an unauthorized activity with his airplane.NTSB DEN01LA140Accident · No injuriesLimited investigationFinal reportMaule MT-7-235 · Las Cruces, NMThe pilot's failure to properly recover from a bounced landing. Contributing factors include his misjudgment of the flare and his lack of total experience in make and model.NTSB DEN01LA138Accident · Serious injuriesLimited investigationFinal reportCessna 182H · Pueblo, COthe loss of engine power due to fuel starvation as a result of the pilot's improper fuel selector position. A factor was the lack of suitable terrain for the forced landing.NTSB DEN01LA137Accident · No injuriesLimited investigationFinal reportBeech A35 · Moab, UTthe pilot's failure to lower the landing gear resulting in a wheels up landing.NTSB CHI01LA277Accident · Serious injuriesLimited investigationFinal reportBlanik L-13 · Marlette, MIGround crew personnel improperly connected the tow winch cable prior to takeoff which resulted in one side of the winch cable coming disconnected. Factors associated with the accident were the ditch and the tree branch which the airplane contacted.