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 ANC00LA106Accident · No injuriesLimited investigationFinal reportBeech C-99 · Deadhorse, AKAn in-flight collision with a bird.NTSB NYC00IA231Incident · No injuriesIncident investigationFinal reportFokker F-100 · Norfolk, VAThe failure of the airplane's ground/flight switch and a malfunction of the thrust reverser deploy switch, which resulted in an in-flight thrust reverser deployment.NTSB MIA00LA240Accident · Serious injuriesLimited investigationFinal reportLake LA-4 · Pensacola, FLThe pilot receiving instruction failure to achieve the proper touch down point during a water landing, and the CFI's improper supervision and failure to initiate a go-around in sufficient time to avoid and in-flight collision with trees, water, and subsequent…NTSB CHI00LA261Accident · No injuriesLimited investigationFinal reportCessna 152 · New London, MOthe fuel exhaustion and inadequate preflight planning/preparation by the pilot.NTSB CHI00LA260Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Chapin, ILthe pilot's failure to refuel the aircraft prior to the flight and exhaustion of the fuel supply. A factor to the accident was the embankment.NTSB CHI00LA259Accident · No injuriesLimited investigationFinal reportCessna 172M · Harbor Springs, MIthe pilot's long touchdown, and inadequate braking to stop on the runway. Factors relating to this accident were the pilot's improper in-flight planning and decision resulting in the long touchdown, and the fence.NTSB ANC00LA105Accident · No injuriesLimited investigationFinal reportCessna 185 · Yakutat, AKThe total fatigue failure of the right main landing gear leg.NTSB ANC00LA104Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Chenega Bay, AKThe pilot's failure to maintain an adequate lookout. Factors involved in this accident were sunglare, and a tall bush next to the airstrip.NTSB ANC00LA103Accident · No injuriesLimited investigationFinal reportCessna 185 · Kaktovik, AKThe pilot's selection of an unsuitable takeoff area on the airstrip. Factors associated with this accident were the rough takeoff area, and the pilot's loss of directional control.NTSB ANC00LA102Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Anchorage, AKThe loss of engine power due to water contamination of the fuel system, the airplane's lack of the required center fuel tank quick drain, and the pilot's inadequate preflight.NTSB NYC00FA229Accident · 2 fatalField investigationFinal reportCessna 182RG · Princeton, KYThe pilot's failure to clear trees, for undetermined reasons.NTSB MIA00LA239Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-34 · Zephyrhills, FLThe student pilot's failure to maintain airspeed on final approach resulting in an inadvertent stall/spin and subsequent in-flight collision with terrain.NTSB LAX00LA304Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164B · Olancha, CAThe pilot's inadequate preflight planning and fuel consumption calculations, which resulted in fuel exhaustion and a loss of engine power.NTSB LAX00LA303Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Reno, NVThe fatigue failure and separation of the right main landing gear.NTSB LAX00FA302Accident · 1 fatalField investigationFinal reportPiper PA-24 · Independence, CAThe pilot's failure to maintain terrain clearance. Factors included night conditions, cockpit lighting, which compromised the pilot's night vision, and drug impairment.NTSB FTW00LA234Accident · Minor injuriesLimited investigationFinal reportCessna 152 · San Antonio, TXThe pilot's failure to maintain aircraft control. A factor was the crosswind.NTSB DEN00LA154Accident · No injuriesLimited investigationFinal reportWaco AGC-8 · Ogden, UTThe pilot's failure to maintain directional control of the aircraft during landing roll. Factors were a tail wind, inadequate weather evaluation by the pilot, and lack of experience in make and model.NTSB CHI00LA258Accident · No injuriesLimited investigationFinal reportBeech K35 · Holland, MIthe misjudged glidepath by the pilot. Factors to the accident were the loose throttle cable due to improper installation by maintenance personnel, and the intentional engine shutdown during the precautionary landing by the pilot.NTSB CHI00FA244Accident · No injuriesField investigationFinal reportBoeing 727-264 · Chicago, ILthe fractured tow bar and the inadequate weld of the tow bar by an unknown person.NTSB SEA00WA163Accident · 2 fatalForeign investigationCessna 208 · Teslin Lake, CanadaNTSB SEA00LA159Accident · No injuriesLimited investigationFinal reportBoeing E75 · Mcminnville, ORThe disconnection of the left tailwheel control cable spring resulting in the positioning of the tailwheel in a right turn condition.NTSB MIA00LA238Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Gainesville, FLThe flight instructor's failure to identify a partial loss of engine power during takeoff roll, and his failure to maintain airspeed while attempting to return to the airport after takeoff resulting in the airplane stalling and descending uncontrolled until…NTSB LAX00LA301Accident · Minor injuriesLimited investigationFinal reportFollmer Q200 · Corona, CAThe failure and separation of one wooden propeller blade for undetermined reasons.NTSB FTW00LA233Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Deerpark, LAthe failure of both pilots to maintain a visual outlook during landing approach. A contributing factor was both pilot's failure to follow recommended traffic patterns.NTSB DEN00LA152Accident · No injuriesLimited investigationFinal reportRosenbarger Lancair IV · Artesia, NMFailure by the pilot in command to maintain control of the aircraft during initial climb following takeoff.NTSB CHI00FA263Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Watertown, WIAircraft control not being maintained during initial climb resulting in a stall/mush. Factors to the accident were the pilot's inadequate preflight planning/preparation, the pilot operating over the airplane's certified maximum gross weight, and the pilot…NTSB ATL00FA081Accident · 3 fatalField investigationFinal reportPiper PA-31-350 · Lumber City, GAPilot's failure to follow instrument procedures and descended below approach minimums and collided with trees. A factor was low clouds.NTSB ANC00LA100Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Arctic Village, AKThe pilot's inadequate compensation for wind conditions, resulting in an inadvertent stall. A factor in the accident was the gusty winds.NTSB SEA00LA165Accident · Serious injuriesLimited investigationFinal reportLadd Nieuport 11 · White Pine, MTThe pilot's failure to maintain adequate airspeed during takeoff after becoming airborne. Contributing factors were his lack of overall recent flight experience and the stall.NTSB NYC00LA228Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Columbus, OHThe pilot's improper recovery from a bounced landing.NTSB NYC00LA227Accident · Minor injuriesLimited investigationFinal reportCessna T337E · Columbus, OHThe pilot's failure to maintain airspeed, resulting from his improper go-around procedures following a rear engine failure. A factor was the pilot's improper fuel management, which resulted in the rear engine failure.NTSB LAX00LA298Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Grass Valley, CAThe pilot's failure to attain proper alignment with the runway during approach for landing. Contributing factors were the pilot's inadequate and improper preflight planning and in-flight decision.NTSB LAX00FA300Accident · 1 fatalField investigationFinal reportBeech K35 · Newberry Spring, CAThe crankshaft's fatigue failure at the site of an electrical arc mark stress riser, during cruise flight. Contributing factors were the pilot's inadequate preflight inspection, improper decision, and maintenance.NTSB IAD00LA075Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Lynchburg, VAPilot's failure to maintain directional control during the landing roll-out.NTSB FTW00LA232Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Helena, ARthe pilot's failure to maintain obstacle clearance. A contributing factor was the sun glare.NTSB FTW00LA231Accident · No injuriesLimited investigationFinal reportCessna T210L · Addison, TXthe electrical wire bundle fire during approach, which tripped the hydraulic motor circuit breaker resulting in collapse of the landing gear on landing.NTSB FTW00LA230Accident · Minor injuriesLimited investigationFinal reportAeronca 65-CA · Liberty Hill, TXthe pilot's inadvertent activation of the left rudder control, which resulted in a loss of control while in cruise flight.NTSB FTW00LA229Accident · Minor injuriesLimited investigationFinal reportAeronca 15AC · Pettigrew, ARthe pilot's failure to maintain obstacle clearance during landing.NTSB DEN01LA026Accident · No injuriesLimited investigationFinal reportSukhoi SU-29 · Longmont, COThe inadequate structural materials (American manufactured verses original Russian materials) used during a major repair.NTSB CHI00MA256Accident · 2 fatalMajor investigationFinal reportNorth American NA-265-80 · Ironwood, MIthe pilot's improper in-flight decision, the pilot's continued flight into known adverse weather, the pilot's failure to turn on the continuous ignition in turbulence, and the pilot's failure to follow the procedures for an airstart. Factors included the…NTSB CHI00LA257Accident · 1 fatalLimited investigationFinal reportAyres S2R-600 · Bad Axe, MIThe inadvertent stall/spin encountered by the pilot. A factor was the low altitude.NTSB SEA00LA161Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Thompson Lake, MTAn improper flare which lead to a hard landing and subsequent main gear collapse as a result of the overload.NTSB SEA00LA158Accident · Minor injuriesLimited investigationFinal reportMaule M-5-235 · Paulina, ORThe pilot's failure to maintain an airspeed above stalling speed (Vs), which resulted in a stall/mush into the terrain. Factors include mountainous/hilly terrain, tall trees, a high density altitude, and the pilot's diverted attention as he attempted to keep…NTSB NYC00LA270Accident · No injuriesLimited investigationFinal reportBeech A36 · Sloatsburg, NYThe pilot's failure to maintain aircraft control. A factor was the pilot's diverted attention.NTSB LAX00GA297Accident · 1 fatalFinal reportBell 412 · Cold Springs, NVfailure of the compressor turbine disc due to cyclic fatigue brought about by repeated operation near or above the engines' temperature/power limits by company personnel over an extended period of time. Factors in the accident were: 1) the high density…NTSB IAD00LA074Accident · Serious injuriesLimited investigationFinal reportUnknown Bensen Gyrocopter · Macedon, NYpilot's failure to maintain control of the gyrocopter. Factors in the accident were the pilot's lack of total flight experience and familiarity with the gyrocopter.NTSB DEN00LA151Accident · No injuriesLimited investigationFinal reportCessna 310D · Watkins, COThe pilot's failure to follow procedures and lower the landing gear prior to landing. Factors were diverted attention and aural perception.NTSB DEN00FA149Accident · 1 fatalField investigationFinal reportCessna 172N · Kamas, UTThe pilot's improper inflight decision to enter a valley at low altitude and attempt a climb towards rising terrain. A factor was exceeding the airplane's climb performance.NTSB NYC00LA230Accident · No injuriesLimited investigationFinal reportRedsell Windrose · Marion, OHThe pilot's failure to maintain control of the glider. Factors in this accident were the strong crosswinds, and thermals, which existed during the flight.NTSB NYC00FA226Accident · 1 fatalField investigationFinal reportCessna 172 · Davis, WVThe pilot-in-command's inadequate weather evaluation, which resulted in a takeoff with a tailwind, and a subsequent inadvertent stall. Factors were a high gross weight, a high density altitude, and a tailwind.