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 LAX01LA016Accident · No injuriesLimited investigationFinal reportAerospatiale AS350-BH · Hilo, HIInadequate maintenance by the helicopter manufacturer during manufacture, which installed skins of inadequate thickness on the tail boom. A factor in the accident was the failure of the manufacturer's quality control system to detect the inadequate thickness.NTSB LAX01FA011Accident · 1 fatalField investigationFinal reportNavion G · Henderson, NVthe pilot's failure to maintain an adequate airspeed while maneuvering to return to the runway following a loss of engine power in the takeoff initial climb. The loss of power was probably due to the pilot's failure to ensure that an adequate fuel supply…NTSB IAD01LA003Accident · Minor injuriesLimited investigationFinal reportPitts S-1A · Mount Pocono, PAPilot's inadequate compensation for wind conditions during landing. A factor was the crosswind.NTSB ATL01LA007Accident · Minor injuriesLimited investigationFinal reportCessna 172-B · Palatka, FLThe CFI's inadequate preflight planning which resulted in fuel exhaustion and the subsequent loss of engine power.NTSB NYC01LA012Accident · Serious injuriesLimited investigationFinal reportPiper PA-60-601P · S. Burlington, VTThe pilot's improper in-flight decision to perform a precautionary landing, and his failure to maintain airspeed after he experienced a partial loss of power on one engine. A factor was the partial loss of power on one engine due to an induction air leak.NTSB LAX01LA012Accident · Minor injuriesLimited investigationFinal reportTolle Venture Model 20 · Madera, CAThe mechanical failure of a fuel sump tank check valve, during takeoff initial climb, that resulted in fuel starvation.NTSB LAX01LA010Accident · No injuriesLimited investigationFinal reportCessna 170B · San Carlos, CAThe pilot's improper and excessive application of brakes resulting from his failure to maintain directional control during landing rollout.NTSB FTW01LA009Accident · Minor injuriesLimited investigationFinal reportBellanca BL17-30 · Waller, TXthe loss of engine power during climb to cruise due to the failure of the crankshaft counterweight. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW01FA003Accident · 1 fatalField investigationFinal reportBeech B19 · Umbarger, TXThe pilot's loss of control due to spatial disorientation. Contributing factors were the low ceilings, the dark night illumination, the lack of visual cues, and the pilot's lack of instrument flight qualification or experience.NTSB CHI01LA013Accident · No injuriesLimited investigationFinal reportRepublic RC-3 · Baraboo, WIthe failure of the number five intake valve spring during initial climbout and that there was no suitable terrain during the forced landing. A factor was the corn crop.NTSB CHI01LA009Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Lansing, MIthe pilot's inaccurate preflight planning. Factors were the fuel exhaustion, the trees, and the bright night condition.NTSB ANC01LA010Accident · No injuriesLimited investigationFinal reportBeech BE-A36 · Nondalton, AKThe pilot's inadvertent retraction of the landing gear during the landing roll.NTSB IAD01LA002Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1A · Philadelphia, PAA hole in the #4 piston for undetermined reasons which resulted in engine oil starvation and engine stoppage.NTSB DEN01FA003Accident · 1 fatalField investigationFinal reportCessna R-182 · Grants, NMthe pilot's continued VFR flight into IMC during cruise. Contributing factors were the dark night light conditions, and the cloudy weather conditions.NTSB CHI01LA008Accident · No injuriesLimited investigationFinal reportWalton RV-6 · Saint Paul, MNThe rudder tube failure, and aircraft control not possible during the flare by the pilot. A factor was the service bulletin not being complied with by the mechanic during the condition inspection.NTSB CHI01LA007Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Highland, ILthe designated examiner not maintaining clearance from the bank/dike. Factors were the designated examiner's delayed remedial action and the bank/dike.NTSB ATL01LA006Accident · No injuriesLimited investigationFinal reportCessna 172K · Indiantown, FLThe pilot had excessive airspeed, misjudged the landing distance, and did not perform a go-around, which resulted in a nose over. The ditch was a contributing factor.NTSB ANC01LA006Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Iliamna, AKThe pilot's inadequate weather evaluation. A factor in the accident was a high wind.NTSB SEA01LA003Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · Twin Falls, IDThe pilot's failure to maintain adequate rotor rpm. Unsuitable terrain was selected for the maintenance test flight operation.NTSB NYC01LA008Accident · No injuriesLimited investigationFinal reportBeech BE-23-B24R · Fork Union, VAThe pilot's inadequate flare which resulted in a hard landing. A factor related to the accident was the uneven landing area condition.NTSB NYC01FA007Accident · 1 fatalField investigationFinal reportBeech E18S · Wash. Ct. House, OHAn undetermined event, which resulted in an off airport landing. A factor in this accident was the night light condition.NTSB MIA01LA002Accident · No injuriesLimited investigationFinal reportHarwell/Gardner WAG-AERO Cubby · Stockbridge, GAThe pilot's failure to maintain a visual lookout during a forced landing resulting in an on-ground collision with a berm on landing roll out. Contributing to the accident was a reported loss of engine power for undetermined reasons.NTSB FTW01LA002Accident · Serious injuriesLimited investigationFinal reportCessna 401A · Andrews, TXThe hard landing due to the pilot's excessive rate of descent. A factor was the loss of engine power due to fuel starvation as a result of the pilot's improper positioning of the fuel selectors.NTSB FTW01FA007Accident · 1 fatalField investigationFinal reportPiper PA-23-160 · Cotulla, TXThe pilot's failure to refuel the airplane which resulted in fuel exhaustion and subsequent loss of engine power. Also contributing to the accident was the pilot's failure to feather the engine.NTSB DEN01LA002Accident · Serious injuriesLimited investigationFinal reportHughes 369FF · Baggs, WYimpact with terrain following a total loss of engine power due to fatigue failure of the turbine-to-compressor coupling. A contributing factor was the unsuitable terrain for a forced landing.NTSB CHI01WA015Incident · No injuriesForeign investigationMcDonnell Douglas DC-9-83 · Santo Domingo, Dominican RepublicNTSB CHI01WA014Accident · Serious injuriesForeign investigationMcDonnell Douglas DC-10-30 · Paris, FranceNTSB CHI01MA006Accident · 2 fatalClass 1 · MajorFinal reportCanadair CL600-2B16 · Wichita, KSthe pilot’s excessive takeoff rotation, during an aft center of gravity (c.g.) takeoff, a rearward migration of fuel during acceleration and takeoff and consequent shift in the airplane’s aft c.g. to aft of the aft c.g. limit, which caused the airplane to…NTSB SEA01FA001Accident · 1 fatalField investigationFinal reportCessna 208B · Lummi Island, WAThe pilot's attempted flight into known adverse weather conditions, and his subsequent failure to maintain altitude above, or clearance with, trees. Factors contributing to the accident included low ceilings, fog, the pilot's low-altitude flight, rising…NTSB NYC01LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Shirley, NYThe pilot's failure to maintain directional control during an aborted landing.NTSB LAX01FA007Accident · 2 fatalField investigationFinal reportCessna P210N · Phoenix, AZThe failure of the pilot to operate the airplane according to the flight manual, resulting in fuel starvation and loss of engine power during a critical phase of flight. A factor was the lack of suitable terrain for a forced landing and the presence of…NTSB SEA01LA002Accident · Minor injuriesLimited investigationFinal reportWsk Pzl Warzawa-Okecie PZL-104 Wilga 80 · Hillsboro, ORClearance from an obstruction was not maintained during the go-around. The pilot's failure to maintain directional control during the landing roll was a factor.NTSB LAX01LA017Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Santa Paula, CAThe failure of the pilot to maintain control of the tail wheel equipped aircraft while taxiing due to excessive taxi speed resulting in a collision with parked aircraft.NTSB LAX01LA005Accident · Serious injuriesLimited investigationFinal reportGalaxy Balloons Galaxy 7 · Inyokern, CAThe pilot's hard landing during a high wind condition.NTSB LAX01FA006Accident · Minor injuriesField investigationFinal reportMcDonnell Douglas 369E · Kernville, CAThe pilot's improper storage of personal items and his inadequate preflight inspection, which resulted in the unlatching of the left rear cabin door during flight and allowing a plastic garment bag to blow out and strike the tail rotor.NTSB CHI01LA003Accident · No injuriesLimited investigationFinal reportCessna 182 · Noblesville, INCarburetor icing and the pilot's inadequate in-flight planning by his delayed use of carburetor heat. A factor associated with the accident was the unsuitable terrain.NTSB ANC01LA005Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKThe pilot's delay in aborting the takeoff run. A factor associated with the accident was glassy water conditions.NTSB NYC01LA011Accident · No injuriesLimited investigationFinal reportBoeing B75-N1 · Warrenton, VAThe pilot's improper recovery from a bounced landing.NTSB NYC01FA005Accident · 4 fatalField investigationFinal reportMitsubishi MU-2B-26A · Edgartown, MAThe pilot's failure to follow instrument flight procedures resulting in a collision with a tree. A factor related to the accident was the low cloud ceiling.NTSB LAX01LA008Accident · No injuriesLimited investigationFinal reportCessna 172H · Hilo, HIAn inadvertent pilot-induced porpoise resulting from the pilot's improper landing flare and inadequate power management.NTSB LAX01FA004Accident · 2 fatalField investigationFinal reportPiper PA-34-200 · San Dimas, CAThe pilots becoming lost and disoriented during an improperly conducted IFR approach, and subsequent missed approach, that led to a collision with rising mountainous terrain. Also causal was the local controller canceling the IFR approach when the pilot…NTSB CHI01LA004Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Sparta, WIthe pilot's inaccurate fuel consumption calculations, improper fuel management, inadequate in-flight planning/decision, flight to destination alternate not performed, and the discontinued planned approach to the initially selected runway. Contributing factors…NTSB ANC01LA004Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Ekwok, AKThe pilot's inadequate compensation for a crosswind condition. A factor in the accident was a crosswind.NTSB SEA01LA004Accident · No injuriesLimited investigationFinal reportMooney M20K · Monroe, WAOil Pump drive gear shaft separated in shear. A collision with a tree stump during the landing roll was a factor.NTSB NYC01WA016Incident · No injuriesForeign investigationCessna 550 · Rouyn-Noranda, CanadaNTSB NYC01LA010Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Lincoln Park, NJThe pilot-in-command's failure to maintain directional control while taxiing.NTSB FTW01RA006Accident · 4 fatalForeign investigationDouglas DC-9-31 · Reynosa, MexicoNTSB ANC01LA003Accident · Minor injuriesLimited investigationFinal reportHelio H-295 · Port Alsworth, AKThe pilot's inadequate preflight inspection, which failed to remove all water from the fuel system. A factor associated with the accident was unsuitable terrain for a forced landing.NTSB ANC01LA002Accident · No injuriesLimited investigationFinal reportCessna 206 · Kiana, AKAn in-flight collision with birds.NTSB NYC01WA009Accident · No injuriesForeign investigationCessna 303 · Jena, Germany