NTSB investigations, 2000
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\") = 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 DEN00LA132Accident · Minor injuriesLimited investigationFinal reportSpencer Long EZE · Farmington, NMFailure of the coolant recovery system, resulting in overheating of the engine. A factor was the soft ground on which the forced landing was made.NTSB DCA00WA076Accident · 60 fatalForeign investigationBoeing 737-200 · Patna, IndiaNTSB CHI00LA206Accident · 1 fatalLimited investigationFinal reportMead Kolb Firestar II · Gwinn, MIthe pilot not obtaining/maintaining altitude/clearance. Factors were the tree and the high density altitude.NTSB ANC00LA091Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Big Lake, AKThe pilot's inadequate compensation for the wind conditions. A factor associated with the accident was a crosswind.NTSB NYC00LA207Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Norwood, MAthe pilot's improper bounced landing recovery. A factor was the pilot's lack of total flight experience.NTSB NYC00LA202Accident · No injuriesLimited investigationFinal reportCessna 172H · Rainelle, WVThe pilot's failure to maintain a proper decent rate. A factor was the up-sloping runway.NTSB NYC00LA199Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5A · Lawrence, MAThe pilot's failure to attain the proper touchdown point and his delayed remedial action. Also causal was the pilot's lack of recent experience. A factor in the accident was the tailwind condition.NTSB NYC00LA198Accident · Serious injuriesLimited investigationFinal reportWarrington Surrel Guppy · Churchville, MDThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. Factors in this accident were an open canopy and a decrease in engine power.NTSB MIA00LA219Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Washington, NCThe inadvertent stall by the pilot-in-command while returning for a precautionary landing. Contributing to the accident was the loose engine cowling.NTSB MIA00LA218Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Immokalee, FLThe inadequate supervision of the pilot rated student by the CFI for her failure to note that the fuel selector was positioned to an empty fuel tank. Also, failure of the CFI to attain the proper rate of descent at touchdown resulting in a hard landing.…NTSB LAX00LA268Accident · No injuriesLimited investigationFinal reportAeronca 7DC · Payson, AZThe pilot's selection of an unsuitable takeoff area. Contributing factors were the high density altitude and proximity to vegetation.NTSB FTW00LA206Accident · No injuriesLimited investigationFinal reportMbb BK-117-A3 · Allen, TXthe pilot's failure to maintain obstacle clearance while hovering the helicopter. A contributing factor was the dark night light conditions.NTSB DEN00LA131Accident · Minor injuriesLimited investigationFinal reportRotorway Executive 162F · Tooele, UTThe pilot's inadequate weather evaluation, which resulted in a downwind landing, and his failure to maintain aircraft control. A factor was the tailwind.NTSB CHI00LA209Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Ashland, WIthe blocked lubricating system and unsuitable terrain.NTSB CHI00LA204Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-1 · Holstein, NEthe settling with power encountered by the pilot. A factor was the sudden windshift.NTSB CHI00LA203Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Streator, ILthe pilot's preflight planning was inadequate which resulted in taking off in the wrong direction on the runway. Factors associated with the accident were the tailwind condition and the crop that the airplane contacted.NTSB CHI00LA201Accident · Minor injuriesLimited investigationFinal reportWitlock CIRCA-NIEUPORT 12 · Peotone, ILthe carburetor icing conditions and the fact that the aircraft was not equipped with carburetor heat protection. A factor to the accident was the crops.NTSB SEA00LA134Accident · No injuriesLimited investigationFinal reportCessna 182 · Snohomish, WAThe right main landing gear failed for undetermined reasons.NTSB LAX00LA289Accident · No injuriesLimited investigationFinal reportCessna 172K · Palo Alto, CAThe pilot of the other airplane's (Cessna) inadequate visual lookout and misjudged distance to the standing Beech.NTSB LAX00LA267Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Lancaster, CAThe pilot's inadequate compensation for gusty winds conditions that resulted in the collision with a power line during final approach.NTSB LAX00LA266Accident · No injuriesLimited investigationFinal reportCessna 152 · San Jose, CAThe pilot's in-flight decision to continue the takeoff and his subsequent delayed decision to abort the takeoff after he noted that the airplane was unable to climb out of ground effect.NTSB LAX00LA265Accident · Serious injuriesLimited investigationFinal reportCessna TR182 · Las Vegas, NVThe pilot's failure to refuel the airplane and his improper fuel consumption calculations.NTSB FTW00LA211Accident · Minor injuriesLimited investigationFinal reportBeech D35 · Decatur, ARThe inadvertent stall while maneuvering to avoid obstructions during a forced landing. A factor was the pilot's failure to extend the landing gear, which resulted in a partial loss of engine power due to the propeller blades striking the runway.NTSB FTW00LA210Accident · 1 fatalLimited investigationFinal reportGrumman-Schweizer G-164B · Ville Platte, LAThe loss of control for an undetermined reason.NTSB DEN00LA130Accident · No injuriesLimited investigationFinal reportCessna 150L · Reserve, NMSeizure of the starter clutch assembly needle bearing, which caused the engine to develop less than full rated power and the airplane to achieve less than expected climb performance. Factors were noncompliance of a service bulletin, unsuitable terrain on…NTSB CHI00LA198Accident · No injuriesLimited investigationFinal reportCessna T188C · Rock Dell, MNthe failure of the pilot to maintain clearance with the terrain.NTSB CHI00FA200Accident · 1 fatalField investigationFinal reportBeech 35 · Columbus, NEthe failure of the pilot to maintain clearance from the power line. Factors were the sunglare and the wire.NTSB ANC00LA090Accident · No injuriesLimited investigationFinal reportMaule ML-5 · Wasilla, AKThe pilot's improper use of the fuel tank selector, resulting in fuel starvation.NTSB ANC00LA089Accident · Minor injuriesLimited investigationFinal reportAeronca 11BC · Wasilla, AKA loss of engine power due to the pilot's failure to use carburetor heat, and an inadvertent stall. A factor associated with the accident was the existence of carburetor icing conditions.NTSB MIA00FA217Accident · 2 fatalField investigationFinal reportCessna 150M · Holly Springs, MSThe failure of the pilot to maintain control while maneuvering the aircraft due to impairment as a result of use of illegal drugs, and the subsequent collision with the terrain during an uncontrolled descent.NTSB LAX00LA262Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Lake Piru, CAThe improper use of the cyclic control by the pilot under instruction, and the flight instructor's lack of remedial action.NTSB FTW00LA213Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Stephenville, TXThe collision with a bird while in cruise flight.NTSB FTW00FA208Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Houston, TXthe loss of engine power for an undetermined reason during maneuvering. Contributing factors were the dark night light conditions and the lack of suitable terrain for the forced landing.NTSB CHI00LA196Accident · Serious injuriesLimited investigationFinal reportAerostar S-77A · River Falls, WIthe unfavorable wind condition for landing and control of the balloon during landing not possible by the pilot.NTSB SEA00FA133Accident · 3 fatalField investigationFinal reportCessna 150E · Ashton, IDThe pilot's failure to maintain clearance from a tree while making a low pass over an outdoor gathering of individuals. Factors include the intentional low pass, a tree located in a shadow generated by the sun's low position at dusk, hilly terrain, and the…NTSB LAX00TA263Accident · No injuriesFinal reportCessna 337G · Battle Mountain, NVFailure of the pilot to extend the landing gear, and his failure to follow the published before landing checklist concerning extension of the landing gear.NTSB LAX00LA271Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Ripley, CAA loss of engine power due to the separation of a connecting rod from the crankshaft.NTSB FTW00LA209Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Kaplan, LAThe loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB DEN00LA143Accident · No injuriesLimited investigationFinal reportMooney M20J · Espanola, NMThe lack of suitable terrain for a forced landing. A factor was a complete loss of power due to mechanical failure.NTSB CHI00LA207Accident · Serious injuriesLimited investigationFinal reportChilian Kitfox 1200 IV · Lowell, INthe incapacitation of the pilot. Factors to the accident were the failure of the pilot to maintain flying speed and the subsequent stall.NTSB CHI00LA202Accident · No injuriesLimited investigationFinal reportCessna 152 · Park River, NDdirectional control not being maintained by the pilot during landing.NTSB CHI00LA199Accident · No injuriesLimited investigationFinal reportCessna 140 · St. Francis, MNthe pilot selected to land in a field that was unsuitable for landing. A factor was the soft field.NTSB CHI00LA195Accident · Serious injuriesLimited investigationFinal reportBoeing Stearman A75N1(PT17) · Windsor, MOfuel exhaustion and the pilot abruptly applying normal brakes during the landing roll. Factors relating to this accident were the precautionary landing, and the pilot's inadequate in-flight planning/ decision.NTSB CHI00LA194Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Olivia, MNthe failure of the pilot to maintain directional control of the aircraft. A factor to the accident was the pocket gopher mound in the wheat field.NTSB SEA00WA135Accident · No injuriesForeign investigationBell 407 · Golden, CanadaNTSB NYC00LA197Accident · Serious injuriesLimited investigationFinal reportFairchild M-62C · Carthage, NYthe pilot's improper decision to depart with obstacles ahead which exceeded the climb capability of the airplane. Factors were the grass runway, and trees at the departure end of the runway.NTSB MIA00LA220Accident · No injuriesLimited investigationFinal reportAeronca 65-TC · Harris, NCThe unsuitable terrain encountered by the pilot while descending for a forced landing. Contributing to the accident was the partial loss of engine power due a blocked fuel line resulting in fuel starvation.NTSB LAX00LA264Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Selma, CAA cracked plastic fuel selector handle that precluded proper engagement of the internal mechanism to fully select a port, and left it in an intermediate position, restricting the fuel supply to the engine, which subsequently lead to a loss of engine power.NTSB FTW00LA207Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Columbus, TXthe failure of both magnetos of the dual-magneto single-drive unit. A factor contributing to the accident was the lack of suitable terrain for the forced landing.NTSB FTW00LA205Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Rio Grande City, TXthe loss of engine power for undetermined reasons. Contributing factors were the pilot flying the airplane with known deficiencies, and the lack of suitable terrain for the forced landing.