NTSB investigations, 2000
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 DEN00LA106Accident · No injuriesLimited investigationFinal reportCessna 170B · Dutch John, UTThe pilot's failure to maintain clearance with the trees. Factors were a high-density altitude and wind gusts.NTSB CHI00LA164Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Sully, IAThe pilot inadvertently applied full flaps during the aborted landing and was not able to gain enough altitude to clear a fence post at the end of the airstrip. Factors associated with the accident were the trees at the approach end of the airstrip, the pilot…NTSB CHI00LA159Accident · No injuriesLimited investigationFinal reportCessna 150M · Bethalto, ILthe improper in-flight decision of the pilot to fly past the Vandalia airport onto Saint Louis Regional and the fuel exhaustion. A factor was the ditch.NTSB ANC00LA068Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kodiak, AKThe pilot's inadequate compensation for wind conditions. Factors associated with the accident were a crosswind, and an inadvertent ground loop/swerve.NTSB ANC00LA067Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Ninilchik, AKThe pilot's failure to maintain directional control during the take-off run. Factors associated with the accident were rough/uneven, soft terrain.NTSB LAX00LA220Accident · Serious injuriesLimited investigationFinal reportSikorsky HH-3F · Wellington, NVthe pilot's encounter with a wind shear while maneuvering at low altitude in mountainous terrain, which resulted in a high descent rate and inadvertent entry into a power settling condition.NTSB DCA00WA064Accident · 1 fatalForeign investigationBeech King Air C90B · Inshas, EgyptNTSB CHI00LA158Accident · No injuriesLimited investigationFinal reportTruthan Searey · Grand Rapids, MIthe pilot's failure to maintain aircraft control when the airplane encountered high winds. Factors which related to this accident were the high crosswind, the wind gusts, and the submerged object.NTSB CHI00LA157Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Flushing, MIaltitude/clearance from the trees not being obtained/maintained by the pilot during the initial climb after takeoff. Factors to the accident were the inadequate preflight planning/preparation by the pilot, including takeoff performance data not being…NTSB ATL00LA064Accident · Serious injuriesLimited investigationFinal reportAeronca 7BCM · Palmetto, FLThe pilot's failure to maintain airspeed during final approach to landing, resulting in an inadvertent stall.NTSB ATL00LA063Accident · Minor injuriesLimited investigationFinal reportHughes 369A · Hampton, GAA total loss of engine power due to foreign object damage to the turbine wheel assembly.NTSB SEA00LA102Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Hillsboro, ORThe pilot's inability to maintain the correct approach airspeed (Vref) on final due to incorrect airspeed indications resulting from a partial blockage of the pitot line. Factors include a quartering tailwind, a wet runway, and the pilot's decision not to…NTSB NYC00LA157Accident · Minor injuriesLimited investigationFinal reportSiai-Marchetti SF260TP · Norfolk, VAFuel starvation of the engine, caused by the failure of the fuel transfer pump.NTSB NYC00LA156Accident · Minor injuriesLimited investigationFinal reportStewart S-51 · Forty Fort, PAThe owner/builder's inadequate design, resulting in total failure of the reduction gear assembly accessory drive shaft.NTSB NYC00LA155Accident · Minor injuriesLimited investigationFinal reportCessna 172R · West Milford, NJA loss of engine power for undetermined reasons.NTSB NYC00IA159Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE Jetstream 3201 · Lexington, KYA misalignment between the bull gear and high speed pinion gearshaft, which resulted in fatigue and a subsequent failure of the bull gear.NTSB LAX00LA219Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Mesa, AZthe failure of the pilot to maintain directional control in that he failed to properly position the ailerons during his landing roll. Gusty, crosswind conditions, from a direction and velocity that equaled the aircraft's maximum demonstrated crosswind…NTSB IAD00LA049Accident · Minor injuriesLimited investigationFinal reportBeech BE-55 · Erie, PAthe pilot's improper fuel management which resulted in fuel starvation and a loss of power to both engines. A factor was the pilot's inadequate pre-flight planning and takeoff with inadequate fuel for the flight.NTSB CHI00LA156Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Indianapolis, INThe improper in-flight decision of the pilot not to land at the nearest airport at the first loss of engine power. Factors to the accident were fuel exhaustion, the excessive fuel flow, and the airport perimeter fence.NTSB CHI00LA155Accident · No injuriesLimited investigationFinal reportEdgerly S-12 · Hartford, MIrestricted directional control. Factors relating to this accident were the rough, uneven runway, and the trees.NTSB ATL00LA062Accident · Serious injuriesLimited investigationFinal reportDaniel J. Zoerb Kitfox · Spruce Pine, NCA total loss of engine power due to carburetor icing conditions. A factor was the mountainous, unsuitable terrain on which to make a forced landing.NTSB ANC00LA066Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Skwentna, AKThe pilot's improper positioning of the fuel tank selector, and fuel starvation. A factor in the accident was the improper service of the airplane's hydraulic brake system.NTSB SEA00LA103Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Kennewick, WAThe pilot's exceedance of the helicopter's hovering capabilities in a downwind hover. Factors included tailwind conditions, the pilot's lack of experience in the type of operation being conducted, and trees in the area where the helicopter settled.NTSB SEA00LA101Accident · Minor injuriesLimited investigationFinal reportBell 206B · Bridgeport, WAAircraft control was not maintained. Inadequate remedial action and diverted attention were factors.NTSB NYC00LA169Accident · No injuriesLimited investigationFinal reportRepublic RC3 · Speculator, NYThe pilot inadvertently lowering the landing gear of the amphibian airplane for a water landing.NTSB MIA00LA187Accident · No injuriesLimited investigationFinal reportCessna 172M · Davis, NCThe pilot's inadequate compensation for wind. The crosswind was a contributing factor.NTSB LAX00LA222Accident · No injuriesLimited investigationFinal reportMooney M20D · Baker, CAThe fuel flow became restricted by remnants of fuel tank sealant that had accumulated in the fuel selector screen. Contributing to the pilot's inability to restart the engine in flight was the empty fuel tank in the left wing and the fuel gauge indication.…NTSB FTW00RA241Accident · Serious injuriesForeign investigationBell 412 · San Juanito, MexicoNTSB FTW00LA202Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Sugar Land, TXThe pilot's improper fuel tank selection, which resulted in fuel starvation. A factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA184Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Mesquite, TXThe pilot's improper compensation for the existing crosswind condition. A factor was the crosswind.NTSB FTW00LA175Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Nacogdoches, TXthe loss of engine power during a go-around resulting from the failure of the worn carburetor heat control cable. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN00LA105Accident · Minor injuriesLimited investigationFinal reportFroelich Lancair IV · Bountiful, UTThe loss of power for undetermined reasons and the pilot's unsuccessful remedial action (dive to avoid the power line). Contributing factors were the power line, the tires and the fence.NTSB CHI00LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Minneapolis, MNthe failure of the engine and the unsuitable terrain for landing encountered by the pilot-in-command. Factors to the accident were the fracture of the crankshaft due to fatigue, excessive main bearing wear, and the swampy terrain condition.NTSB ATL00LA060Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Foley, ALThe pilot exceeding the performance capability of the airplane during takeoff. A factor was the trees.NTSB ATL00FA061Accident · 2 fatalField investigationFinal reportCessna 150G · Oxford, MSThe certified flight instructor's failure to maintain airspeed during climbout.NTSB FTW00LA177Accident · No injuriesLimited investigationFinal reportStarduster Too SA300 · Spicewood, TXThe pilot's failure to maintain directional control of the airplane during the landing roll. A factor was the muddy terrain condition.NTSB FTW00LA176Accident · No injuriesLimited investigationFinal reportBellanca 17-31ATC · Del Rio, TXThe separation of the #3 connecting rod, piston, and cylinder. A factor was the lack of suitable terrain for the forced landing.NTSB DCA00WA059Incident · No injuriesForeign investigationBoeing 747F · Frankfurt, GermanyNTSB CHI00LA151Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Maddock, NDAircraft control not being maintained by the pilot. Factors to the accident were the turbulent weather condition, the inadvertent stall, and the inadequate weather evaluation by the pilot.NTSB CHI00IA152Incident · No injuriesIncident investigationFinal reportBoeing 767-222 · Lafayette, INThe blocked drain lines in the canted pressure deck and the frozen aileron cable.NTSB LAX00LA218Accident · No injuriesLimited investigationFinal reportBeech 95 · Sun Valley, AZThe certified flight instructor's (pilot-in-command) inadequate supervision of his dual student, who prematurely retracted the landing gear.NTSB FTW00LA178Accident · Minor injuriesLimited investigationFinal reportGulfstream-Schweizer G-164D · Welsh, LAThe excessive wear of the reduction gearbox's 1st stage sungear, which resulted in its subsequent fatigue fracture and failure. Factors were the operator not performing the recommended overhaul of the engine, and a lack of suitable terrain for the forced…NTSB FTW00LA174Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Greenville, TXThe pilot's failure to maintain directional control during the landing roll, which resulted in an inadvertent ground loop.NTSB DEN00LA103Accident · No injuriesLimited investigationFinal reportCessna 185B · Moab, UTThe fire in the engine compartment for unknown reason.NTSB SEA00LA099Accident · Serious injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Colfax, WAThe pilots failure to maintain clearance from power transmission lines.NTSB LAX00LA216Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Brentwood, CAThe student's improper execution of a quick-stop maneuver in that he misjudged his altitude and failed to terminate at a stationary hover prior to descending to a low hover. This resulted in an excessive engine power requirement and the student improperly…NTSB FTW00LA170Accident · No injuriesLimited investigationFinal reportAero Commander 700 · Breckenridge, TXFuel exhaustion as a result of an inaccurate fuel quantity indicating system. A factor was the lack of suitable terrain for the forced landing.NTSB DEN00FA104Accident · 2 fatalField investigationFinal reportCessna P206 · Howard, COThe pilot's failure to maintain aircraft control. A factor was a thunderstorm.NTSB DEN00FA102Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Kiowa, COthe flight instructor's failure to maintain aircraft control while practicing stall maneuvers, which resulted in an inadvertent spin.NTSB CHI00LA153Accident · Minor injuriesLimited investigationFinal reportEaton Acro Sport I · Malden, MOthe water contamination of the fuel system and the inadequate preflight of the airplane by the pilot. The inoperative fuel system drain was a contributing factor. The wheat was a contributing factor.