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 LAX00LA110Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200 · Big Bear City, CAThe pilot's selection of a final approach airspeed in variance with the manufacturer's recommendations, which was too slow for the gusty and variable crosswind conditions, which resulted in a stall/mush and a hard landing.NTSB DCA00WA029Accident · No injuriesForeign investigationBoeing B737-400 · Porto Alegre, BrazilNTSB CHI00LA084Accident · No injuriesLimited investigationFinal reportCessna 150M · Marshall, MOthe go-around not performed, the improper flare, and recovery from a bounced landing not performed by the pilot. The crosswind was a contributing factor.NTSB CHI00LA079Accident · Serious injuriesLimited investigationFinal reportBeech BE-35V · Bloomington, INthe improper major overhaul of the engine by company maintenance personnel. The tree was a contributing factor.NTSB MIA00LA098Accident · No injuriesLimited investigationFinal reportBell 412 · Karns, TNThe pilot's failure to maintain a visual lookout while repo sitioning the helicopter at a road side landing zone resulting in an in-flight (hover) collision with a tree.NTSB LAX00LA113Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Selma, CAThe failure and separation of the right landing gear axle during taxi from landing for undetermined reasons.NTSB FTW00LA088Accident · No injuriesLimited investigationFinal reportCessna 172K · Alpine, TXThe pilot's failure to maintain aircraft control during landing. A factor was the crosswind condition.NTSB FTW00LA087Accident · No injuriesLimited investigationFinal reportCessna 150L · Rush Springs, OKThe pilot's failure to maintain control of the aircraft during landing roll. Factors were the pilot's diverted attention to raising the flaps and the high wind conditions.NTSB FTW00LA086Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · New Ulm, TXThe pilot's failure to maintain clearance with a fence during the aborted landing.NTSB DEN00LA054Accident · No injuriesLimited investigationFinal reportMooney M-20C · Boulder, COThe pilot not following procedures in that he did not periodically clear the engine during an extended glide. The factors were carburetor icing, weather conditions conducive to carburetor ice, and lack of suitable terrain for landing.NTSB MIA00WA096Accident · 3 fatalForeign investigationCessna 210 · Puerto Barrios, GuatemalaNTSB DEN00FA053Accident · 1 fatalField investigationFinal reportCessna 182E · El Prado, NMThe pilot's improper preflight planning/preparation in that he initiated flight into known adverse weather, and continued VFR flight into IMC to the point where remedial action was not possible. Factors were the weather conditions that included snow, low…NTSB CHI00LA082Accident · 1 fatalLimited investigationFinal reportEllis Q2 · Shelbyville, INaircraft control not being maintained by the pilot during the attempted go-around. Factors to the accident were the inadequate preflight by the pilot, which resulted in fuel exhaustion. An additional factor to the accident was the inadvertent stall/mush.NTSB ANC00LA030Accident · No injuriesLimited investigationFinal reportCessna 180H · Ophir, AKThe pilot's selection of an unsuitable taxi area. A factor associated with the accident was the soft, snow-covered terrain.NTSB MIA00LA094Accident · No injuriesLimited investigationFinal reportNorth American NA-64 · Clearwater, FLA total loss of engine power due to fuel starvation for und etermined reasons. This resulted in a forced landing to none suitable terrain, and a subsequent in-flight collision with trees and terrain.NTSB LAX00LA108Accident · No injuriesLimited investigationFinal reportBeech 35 · Desert Center, CAThe pilot's inadequate fuel management, his inaccurate fuel consumption calculations, and his improper use of the fuel selector.NTSB CHI00FA080Accident · 3 fatalField investigationFinal reportBeech 95-B55 · Moorhead, MNthe pilot's failure to maintain aircraft control during the missed approach. Factors to the accident were, the pilot's improper decision to attempt the approach in weather conditions below the approach/landing minimums, the weather, the pilot's lack of…NTSB IAD00FA023Accident · 1 fatalField investigationFinal reportAerotechnik L-13 SEH Vivat · Plymouth, MAthe flight instructor's inadequate compensation for the wind conditions. A factor was the flight instructor's improper use of speed brakes and the strong gusty winds with downdrafts.NTSB DCA00WA028Accident · No injuriesForeign investigationBoeing B-767-300ER · Harare, ZimbabweNTSB NYC00LA084Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Center Harbor, NHThe pilot-in-command attempted a low pass and misjudged his altitude.NTSB NYC00RA104Accident · No injuriesForeign investigationSchweizer 269C · Prince George, CanadaNTSB LAX00LA107Accident · Minor injuriesLimited investigationFinal reportHiller H-12E · Byron, CAThe pilot's inadequate visual lookout while maneuvering in proximity to wires. A contributing factor was the sun glare, which reduced the wire's conspicuity.NTSB LAX00LA104Accident · No injuriesLimited investigationFinal reportCohen VAN'S RV-6 · Camarillo, CAFailure of the pilot to maintain control of the aircraft during a crosswind takeoff, which resulted in a collision with the terrain and a runway light.NTSB LAX00IA106Incident · No injuriesIncident investigationFinal reportEmbraer 120 · Fresno, CAMoisture contamination of the elevator trim actuator units resulting in their failure to operate at below freezing temperaturesNTSB CHI00LA081Accident · No injuriesLimited investigationFinal reportCessna 172R · Waterford, MIthe directional control not obtained/maintained by the dual student and the remedial action not performed by the certified flight instructor. Contributing factors were the crosswind and the snow bank.NTSB CHI00LA078Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Saginaw, MIthe pilots failure to maintain directional control of the aircraft. Factors were the icy runway and the snowbank.NTSB CHI00LA076Accident · Serious injuriesLimited investigationFinal reportFokker F28 MK100 · Chicago, ILthe driver of the refueling truck fell asleep which resulted in him not maintaining clearance with the parked aircraft. Factors associated with the accident were severe obstructive sleep apnea and significant hypersomnolence which resulted in chronic fatigue.NTSB CHI00LA074Accident · No injuriesLimited investigationFinal reportCessna 150H · Wisconsin Rapid, WIThe student pilot's failure to maintain directional control. Factors were the pilot's lack of total experience and the snowbank.NTSB ANC00LA029Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-T3 · Kotzebue, AKThe pilot descended below the minimum descent altitude. Factors associated with this accident were the task overload of the pilot during the instrument approach, and not performing a level off.NTSB SEA00LA046Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-8-63F · Seattle, WAInadequate inspection of the number 1 and 2 engine cowls by company maintenance personnel and inadequate preflight inspection by the flight engineer, resulting in unsecured cowls separating from the aircraft during takeoff. A factor was unsecured number 1 and…NTSB MIA00LA095Accident · No injuriesLimited investigationFinal reportAerospatiale SA341G · Delray, FLa collision with a fence while at a hover, which resulted in the helicopter rolling over.NTSB CHI00LA075Accident · Minor injuriesLimited investigationFinal reportKretsinger Bensen B8M · Wayzata, MNthe pilot's poor inflight planning in that he turned into a tailwind which resulted in diminished airspeed. Factors associated with the accident were the tailwind, low altitude maneuvering, the snow covered terrain, and the pilot's inability to successfully…NTSB CHI00LA072Accident · 1 fatalLimited investigationFinal reportCessna 180 · Tower, MNthe passenger not maintaining clearance from the rotating propeller.NTSB ATL00LA028Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Nashville, TNThe pilot's failure to maintain directional control during the landing roll.NTSB MIA00LA093Accident · No injuriesLimited investigationFinal reportSchweizer SGS2-33A · Miami, FLthe pilot planned the approach too low, which resulted in inadequate altitude to clear powerlines, and the subsequent in-flight collision with the ground.NTSB FTW00LA085Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Weir, TXThe delayed aborted takeoff by the pilot. Factors were the pilot's intentional ground loop/swerve and the tail wind.NTSB ATL00LA027Accident · No injuriesLimited investigationFinal reportCessna 152 · Leesburg, FLThe pilot's inadequate pre-flight planning resulting in a total loss of engine power due to fuel exhaustion.NTSB SEA00LA045Accident · No injuriesLimited investigationFinal reportCessna 150H · Spangle, WAExhaustion of the fuel supply due to a leaking fuel tank system. Factors contributing to the accident were, inaccurate fuel quantity sensors, the lack of suitable terrain in the area of the forced landing, and a fence alongside the dirt upon which the pilot…NTSB NYC00LA083Accident · No injuriesLimited investigationFinal reportCessna 310R · Sandusky, OHThe pilot's decision to land on a runway that was covered with ice and snow, without obtaining current wind information. Factors were the 20-knot tailwind and the snow-covered runway.NTSB LAX00LA109Accident · Minor injuriesLimited investigationFinal reportHughes 500C · Pohnpei (Pacific Ocean)The pilot reported that he and the observer were planning to conduct tuna spotting operations. This was to be the first flight of the day. After takeoff, about 100 to 150 feet above sea level, the helicopter began an uncommanded right turn, followed by an…NTSB LAX00LA105Accident · Minor injuriesLimited investigationFinal reportAyres · Elko, NVthe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the ensuing forced landing.NTSB DEN00IA052Incident · No injuriesIncident investigationFinal reportCessna TR182 · Fort Carson, COThe pilot electing to fly the aircraft with known deficiencies which resulted in a catastrophic engine failure. Factors were a connecting rod failure, and low engine oil level.NTSB DCA00MA026Accident · 3 fatalClass 1 · MajorFinal reportDouglas DC-8-71F · Rancho Cordova, CAA loss of pitch control resulting from the disconnection of the right elevator control tab. The disconnection was caused by the failure to properly secure and inspect the attachment bolt.NTSB ANC00LA028Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Willow, AKThe pilot's selection of unsuitable terrain for landing. Factors in the accident were soft, snow covered terrain.NTSB SEA00LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · Billings, MTDirectional control was not maintained. Inadequate remedial action was a factor.NTSB NYC00LA082Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Mount Holly, NJEngine failure due to the disconnection of the intake manifold from the #3 cylinder, as a result of improper maintenance.NTSB MIA00LA092Accident · Serious injuriesLimited investigationFinal reportKitchens Revolution Mini 500B · Hazelhurst, MSthe pilot's failure to maintain control of the helicopter during a practice autorotation, by allowing the rotor rpm to become inadequate to cushion the touchdown, which resulted in a hard landing, and subsequent roll over.NTSB LAX00LA100Accident · No injuriesLimited investigationFinal reportBell 47G5 · Riverbank, CAthe pilot's failure to verify that ground personnel had disconnected the loading hose from the hopper before takeoff, resulting in restricted directional control and a hard landing.NTSB LAX00LA088Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Ukiah, CAfailure of the pilot to comply with the checklists in the Owner's Handbook, resulting in a total loss of engine power due to fuel exhaustion.NTSB LAX00GA102Accident · No injuriesFinal reportCessna T210M · Elfrida, AZThe company mechanic's failure to correctly install one or more of the crankshaft counterweight pin retaining plate snap rings, specifically ensuring that the snap rings were fully seated in their grooves. This led to the complete separation of the No. 2…