NTSB investigations, 2000
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\") = 2000 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") = 2000 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 MIA00LA228Accident · 1 fatalLimited investigationFinal reportQuicksilver MXL II Sport · Clyo, GAThe failure of the pilot to maintain control of the aircraft due to impairment by use of drugs, and the resultant uncontrolled descent and in-flight collision with the terrain.NTSB LAX00LA277Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Boulder City, NVThe fatigue fracture and separation of the No. 6 cylinder fuel injector line due to the company maintenance personnel's failure to comply with an Airworthiness Directive. A factor in the accident was the company's decision to operate the aircraft in…NTSB IAD00LA066Accident · No injuriesLimited investigationFinal reportWaco UPF7 · Warrenton, VAthe loss of engine power over unsuitable terrain due to an inoperative magneto.NTSB IAD00LA065Accident · Serious injuriesLimited investigationFinal reportRotorway Exec 90 · Circleville, OHPilot's improper decision to depart a confined area with two people onboard, which resulted in a loss of rotor RPM and collision with a utility pole and wires.NTSB DEN00LA138Accident · No injuriesLimited investigationFinal reportCessna 182P · Broomfield, COThe pilot's inaccurate recovery from a bounced landing. Factors were lack of total pilot experience and lack of pilot experience in aircraft make and model.NTSB DCA00WA074Incident · Minor injuriesForeign investigationBoeing 747-2B6B · Montreal, CanadaNTSB CHI00IA221Incident · No injuriesIncident investigationFinal reportAerospatiale ATR 42-300 · Champaign, ILThe failure of the aileron trim switch due to foreign material contamination.NTSB SEA00LA139Accident · No injuriesLimited investigationFinal reportCessna 180H · Hailey, IDFailure to adequately compensate for wind conditions.NTSB NYC00LA211Accident · No injuriesLimited investigationFinal reportCessna 150 · Baltimore, OHThe pilot's delay in aborting the takeoff.NTSB NYC00LA208Accident · No injuriesLimited investigationFinal reportSchreder HP-11-A · Dansville, NYThe pilot's improper in-flight decision to continue the flight with an unfavorable wind. A factor related to the accident was the loss of thermal lift.NTSB NYC00LA205Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Logan, WVFuel exhaustion of the engine due to improper fuel consumption calculations performed by the pilot.NTSB MIA00LA227Accident · Minor injuriesLimited investigationFinal reportBell 206A-1 · Bennettsville, SCThe pilot's failure to use proper remedial action to counteract a loss of tail rotor effectiveness resulting in collision with terrain during the subsequent uncontrolled descent.NTSB DEN00LA137Accident · No injuriesLimited investigationFinal reportMooney M20C · Longmont, COThe pilot's improper fuel tank selector position resulting in fuel starvation and the ditch impacted during the landing roll. A contributing factor was the pilot's failure to follow published procedures and directives.NTSB CHI00LA220Accident · Serious injuriesLimited investigationFinal reportFloroski Anderson Kingfisher · Deerwood, MNthe open carburetor heat air box resulting in a loss of engine power, the diminished climb rate and the altitude/clearance not possible by the pilot. Factors were the trees and the bent carburetor heat push-pull rod.NTSB CHI00LA217Accident · No injuriesLimited investigationFinal reportCessna 182S · Millard, NEthe improper recovery from the bounced landing and the porpoise encountered by the pilot. Factors were the misjudged flare by the pilot and the runway light.NTSB CHI00LA215Accident · No injuriesLimited investigationFinal reportLutke Rotoway Exec 90 · Kalamazoo, MIthe loss of main rotor rpm due to the failure of the top engine mount and the subsequent loss of the main rotor drive belt tension. A factor was the confined area landing zone.NTSB CHI00FA214Accident · 1 fatalField investigationFinal reportPiper PA-23 · Dodge Center, MNThe pilot not maintaining airplane control in his turn back in the direction of the airport and the pilot not performing an emergency landing straight ahead. Factors were the water and debris contamination found in the fuel screens and carburetor bowl and the…NTSB SEA00TA138Accident · No injuriesFinal reportCessna 182R · John Day, ORThe pilot's improper flare on touchdown resulting in a hard landing. A factor was the pilot's entrance into an inadvertent porpoise condition.NTSB SEA00LA141Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Grand View, IDInternal deterioration of a fuel line, resulting in loss of engine power. Factors included obstruction of the fuel line, fuel starvation, and a fence in the forced landing area.NTSB SEA00LA140Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Lone Pine, ORThe complete loss of engine power for undetermined reasons. Factors include an irrigation system in the field where the forced landing took place, and the pilot's intentional initiation of a ground loop in order to miss the pipes of the irrigation system.NTSB SEA00LA137Accident · No injuriesLimited investigationFinal reportBeaver Ferguson F-II · Benton City, WAThe pilot's failure to approach the strip with adequate airspeed for the conditions (resulting in a stall/mush situation), and his failure to maintain adequate altitude and/or clearance above a power line on the approach path. Factors included crosswind…NTSB LAX00MA273Accident · 7 fatalMajor investigationFinal reportAerospatiale AS 355F1 · Kahului, Maui, HIThe pilot's inadequate decision by which he continued visual flight rules flight into instrument meteorological conditions. Also causal was his failure to maintain terrain clearance resulting in a collision with mountainous terrain. A contributing factor was…NTSB LAX00LA275Accident · Minor injuriesLimited investigationFinal reportSteel/Vans RV6 · Winnemucca, NVA loss of power due to overheating resulting from the failure of the engine build-up facility to install a vernatherm.NTSB CHI00LA213Accident · No injuriesLimited investigationFinal reportCessna 120 · Shawano, WIInadequate preflight planning and the pilot's delay in aborting the takeoff. A factor was the road embankment.NTSB ANC00FA093Accident · 1 fatalField investigationFinal reportCessna 180 · Thorne Bay, AKThe pilot-in-command's inadvertent stalling of the airplane.NTSB NYC00LA204Accident · No injuriesLimited investigationFinal reportBoeing PT17 · Easton, MDThe pilot's failure to maintain aircraft control.NTSB MIA00RA224Accident · 2 fatalForeign investigationDouglas DC-3 · Nassau, BahamasNTSB MIA00LA226Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Statesboro, GAThe pilots failure to calculate his takeoff distance for the conditions, resulting in an in-flight collision with a fence, trees, and the terrain. A factor in the accident is the FAA's failure to require of the manufacturer and the manufacturer's failure to…NTSB FTW00LA215Accident · Minor injuriesLimited investigationFinal reportCessna 210D · Lubbock, TXThe pilot's improper aircraft handling as a result of his alcohol impairment.NTSB ANC00LA092Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Anchorage, AKThe failure of the pilot-in-command (CFI) to adequately supervise the instructional flight. Factors in the accident were an inadvertent spin entry by the student, and the pilot-in-command's failure to utilize adequate altitude for a stall demonstration.NTSB NYC00MA201Accident · 2 fatalMajor investigationFinal reportGrumman G-159 · Linneus, METhe pilot-in-command's failure to maintain minimum control airspeed, which resulted in a loss of control. Factors in this accident were clouds, and a loss of engine power for undetermined reasons, while in cruise flight above the airplane's single engine…NTSB NYC00LA203Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Columbus, OHa partial power loss for undetermined reason(s).NTSB LAX00LA276Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Cave Creek, AZThe pilot's inadequate in-flight planning/decision to attempt a hover in atmospheric conditions and over terrain that would require maximum helicopter performance, and which would leave no viable alternate actions in the event of difficulties.NTSB LAX00IA272Incident · No injuriesIncident investigationFinal reportCanadair CL-65 · Monterey, CAFatigue failure of the bell gear in the horizontal stabilizer trim actuator system.NTSB FTW00LA214Accident · 1 fatalLimited investigationFinal reportBurton/Boyton Celerity · Horseshoe Bend, ARThe loss of control while maneuvering for an undetermined reason.NTSB DEN00LA134Accident · Serious injuriesLimited investigationFinal reportCessna 310D · Pagosa Springs, COThe pilot inadvertently stalling the airplane. Factors were the pilot's failure to use the entire available runway, the high density altitude weather condition, and a partial loss of power on one engine due to a burned exhaust valve.NTSB SEA00LA136Accident · 1 fatalLimited investigationFinal reportErcoupe 415-D · Hamilton, MTThe excessive rate at which the student pilot allowed the aircraft to descend into the runway surface while attempting to land. Factors include the pilot's lack of experience in airplanes.NTSB MIA00LA223Accident · No injuriesLimited investigationFinal reportCessna 172P · Jesup, GAThe failure of the student pilot to maintain directional control during takeoff resulting in an excursion off the runway and collision with adjacent foliage. A factor in the accident was the student's decision to takeoff downwind.NTSB LAX00LA270Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · San Luis Obispo, CAThe pilot's inadequate visual lookout while taxiing to the runway, which resulted in his failure to see and avoid the fuel truck.NTSB IAD00RA064Accident · 1 fatalForeign investigationHughes 369D · Nuuk, GreenlandNTSB IAD00LA063Accident · No injuriesLimited investigationFinal reportBeech BE-55 (T42A) · Chesapeake, VAthe pilot's misjudgment of his altitude/clearance above the runway during the aborted takeoff which resulted in an improper flare for landing. A factor in the accident was the pilot's premature rotation during the takeoff roll.NTSB IAD00LA062Accident · No injuriesLimited investigationFinal reportBoeing Stearman E75-N1 · Atwater, OHLoss of total engine power due to a fractured crankshaft.NTSB FTW00LA212Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-401 · Panhandle, TXThe pilot's failure to maintain airspeed, which resulted in a stall.NTSB DEN00FA136Accident · 2 fatalField investigationFinal reportGrumman American AA-5 · Moab, UTThe pilot in command exercising poor judgment and exceeding the aircraft's turning capability. Contributing factors were the pilots' attention being diverted, flying into a known blind canyon, high temperature, and high density altitude.NTSB CHI00LA212Accident · 1 fatalLimited investigationFinal reportHess RH-1 Falcon · New Castle, INaircraft control not attained by the pilot.NTSB CHI00LA208Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Warrensburg, MOinadequate airspeed on takeoff that resulted in a stall/mush condition. Factors associated with the accident were the wet, grass runway, and the trees near the departure end of the runway.NTSB CHI00LA205Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Decatur, MIthe left main landing gear brake was locked during landing. A factor associated with the accident was the uneven terrain on which the landing was made.NTSB NYC00LA200Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Richfield Sprng, NYFailure of the number two cylinder main bearing for undetermined reasons.NTSB MIA00LA222Accident · No injuriesLimited investigationFinal reportBell 47G-2A · Covington, TNthe pilot allowed the helicopter to get too low while hovering, which resulted in the tail rotor striking the ground, the separation of the blade, and subsequent force landing.NTSB MIA00FA221Accident · 1 fatalField investigationFinal reportBeech 58 · Hernando, MSThe arcing of an electrical wire behind the instrument panel and the associated cracking of fuel and oil lines. Also causal was the pilot's inappropriate remedial action not in accordance with the emergency checklist.