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 CHI00LA174Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Grant, MIthe pilot's failure to maintain control of the airplane which resulted in a stall/mush condition. Factors associated with the accident were the trees and gusty wind conditions which resulted in turbulence on takeoff.NTSB CHI00LA172Accident · No injuriesLimited investigationFinal reportCessna 172N · Canton, MIthe CFI delayed initiating a go-around during the landing. Factors associated with the accident were the student pilot's inadequate handling of the airplane, the crosswind condition, and the soft terrain on which the airplane touched down.NTSB ATL00LA068Accident · No injuriesLimited investigationFinal reportDouble D Enterprises Rans S-12 · Baneberry, TNThe pilot's inadequate compensation for wind conditions. Factors were the trees, and gusting winds.NTSB ANC00LA080Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Nikiski, AKA bear running onto the landing area during the landing flare. A factor associated with the accident was the high vegetation on the edge of the airstrip.NTSB SEA00LA114Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Ephrata, WAThe pilot-in-command's failure to maintain directional control during landing roll.NTSB NYC00LA175Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Robbinsville, NJThe pilot's inadequate compensation for wind conditions, which resulted in a loss of aircraft control. A factor was a crosswind.NTSB LAX00LA243Accident · No injuriesLimited investigationFinal reportCessna A185F · Marana, AZthe pilot's excessive use of wheel brakes during the landing roll resulting in the airplane's nosing over.NTSB CHI00FA171Accident · 1 fatalField investigationFinal reportCessna 210J · Sumner, IAfailure of the pilot to maintain clearance with the terrain after flight into adverse weather. Contributing factors were the thunderstorms and lack of instrument certification by the pilot.NTSB FTW00LA185Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Mckinney, TXThe flight instructor's inadequate supervision of the landing resulting in the loss of directional control by the student pilot.NTSB DEN00LA116Accident · No injuriesLimited investigationFinal reportCessna 310C · Erie, COA sudden and unexpected encounter with a downdraft while on final approach. A factor was the transmission wire.NTSB CHI00WA175Accident · 3 fatalForeign investigationBeech V35B · Stromsnasbruk, SwedenNTSB CHI00LA173Accident · Minor injuriesLimited investigationFinal reportMcclish Funk B85C · Gardner, KSan improper modification to the engine which allowed a bearing to be misaligned, thus restricted the flow of oil through the engine. A factor associated with the accident was the wet field in which the forced landing was made.NTSB CHI00FA170Accident · 1 fatalField investigationFinal reportAeronca 7AC · Lakeville, MNthe pilot not maintaining aircraft control and the stall/spin she encountered during the approach on base to final. A factor was the pilot passenger not detecting the remedial action needed to correct the aircraft's nose up attitude during the approach.NTSB ATL00LA073Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Key West, FLA landing gear collapse resulting from the pilot's unsuccessful attempt to complete the manual gear extension due to physical strength overload. A factor was the complete electrical system failure during cruise flight.NTSB ATL00LA066Accident · No injuriesLimited investigationFinal reportCessna 172N · Atlantic Ocean (Atlantic Ocean)Loss of engine power for undetermined reasons. A factor was the pilot failed to use carburetor heat during the descent.NTSB ANC00LA079Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Skwentna, AKThe pilot's inadequate compensation for wind conditions. Factors in the accident were the presence of a tailwind, the pilot's inadvertent touchdown, and a short landing area bordered by high vegetation.NTSB ANC00LA078Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kotzebue, AKThe failure of the pilot to maintain directional control of the airplane during takeoff.NTSB SEA00LA112Accident · No injuriesLimited investigationFinal reportAyres S2R-G10 · Boardman, ORThe pilot's failure to maintain adequate airspeed through an area of turbulence, resulting in entry into a stall/mush condition. Factors included tailwind conditions, trees at the end of the runway, terrain-induced turbulence, and crops near the airstrip.NTSB NYC00LA174Accident · No injuriesLimited investigationFinal reportEnstrom 280 FX · Springdale, OHThe pilot's inadequate preflight of the helicopter, and his subsequent failure to monitor his fuel supply, which resulted in a power loss due to fuel exhaustion, over unsuitable terrain.NTSB MIA00FA190Accident · 4 fatalField investigationFinal reportLearjet 55 · Boca Raton, FLThe failure of the pilot's of both airplanes to maintain a visual lookout (while climbing and maneuvering) resulting in an in-flight collision and subsequent collision with residences and terrain.NTSB LAX00LA241Accident · No injuriesLimited investigationFinal reportCessna 206 · Gerlach, NVThe pilot's attempt to takeoff from an unsuitable area and his collision with a dirt berm.NTSB LAX00LA240Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 1-26C · Tehachapi, CAThe pilot's failure to maintain aircraft speed and control while maneuvering to land.NTSB LAX00LA239Accident · 1 fatalLimited investigationFinal reportBell UH-1B · Arbuckle, CAthe partial failure of the tail rotor pitch change control rod that resulted in an attempted run-on landing in dark night conditions.NTSB IAD00FA053Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Bealeton, VAthe flight instructor's improper pre-flight plan and decision to land and depart an airport with insufficient runway. A factor in the accident was the short grass runway with a 100-foot obstruction at the end.NTSB DEN00LA117Accident · No injuriesLimited investigationFinal reportBeech M35 · Los Alamos, NMThe pilot's misjudgment of distance/speed resulting in an overrun and subsequent collision with a blast fence. Contributing factors were high density altitude, a tailwind, and the blast fence.NTSB CHI00LA169Accident · No injuriesLimited investigationFinal reportCessna 172N · Greenville, ILthe student pilot failed to properly flare the airplane while landing. A factor associated with the accident was the student pilot's lack of total experience.NTSB ATL00LA067Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Tylertown, MSLoss of directional control due to separation of the tail-wheel spring assembly. A factor was the ditch which run adjacent to the runway.NTSB ANC00TA075Accident · No injuriesFinal reportPiper PA-18 · Quinhagak, AKThe pilot's inadequate compensation for wind conditions during takeoff. Factors associated with the accident were the sudden windshift from a crosswind to a tailwind.NTSB ANC00LA077Accident · No injuriesLimited investigationFinal reportCessna 170B · Wasilla, AKThe pilot's failure to maintain directional control during landing. A factor associated with the accident is the pilot's excessive use of the brakes.NTSB ANC00FA076Accident · 1 fatalField investigationFinal reportCessna 172N · Tuntutuliak, AKThe pilot's disregard of the existing wind conditions, and an inadvertent stall. Factors associated with the accident are a tailwind, and wind gusts.NTSB SEA00LA113Accident · No injuriesLimited investigationFinal reportCessna 172M · Wallace, IDThe pilot's failure to maintain airspeed and his failure to maintain clearance from the trees. Related factors were trees and mountainous terrain.NTSB NYC00LA176Accident · Minor injuriesLimited investigationFinal reportSchwarz Avid Amphibian · Fredericksburg, VAA failure of the propeller reduction gear assembly for undetermined reasons, which resulted in a loss of thrust.NTSB LAX00LA260Accident · No injuriesLimited investigationFinal reportCessna 172N · Santa Ana, CAThe loss of engine power during the initial takeoff climb, at too low an altitude to afford remedial action, because of an ingested valve, and the airplane's subsequent collision with the ground adjacent to the runway.NTSB ANC00LA074Accident · Minor injuriesLimited investigationFinal reportCessna 206 · King Salmon, AKThe inadequate visual lookout by the pilot of the other airplane, and the inadequate radio traffic advisories by the pilots of both airplanes.NTSB SEA00LA111Accident · Minor injuriesLimited investigationFinal reportStinson 108-1 · Mountain Home, IDThe pilot's decision to takeoff in unfavorable weather conditions without first calculating takeoff performance data. Factors include gusty winds, downdrafts, terrain-induced turbulence, and rough/uneven terrain where the pilot elected to make the…NTSB SEA00LA110Accident · 2 fatalLimited investigationFinal reportHoye Kolb Twinstar MK III · Bigfork, MTThe pilot's failure to maintain aircraft control. Inadequate altitude for recovery was a factor.NTSB MIA00TA189Accident · Serious injuriesFinal reportBell OH-58 · Rome, GAThe pilots failure to ensure the helicopter was on level terrain after landing. The left skid came off the ground after the passenger exited the helicopter, the slope capability was exceeded, the helicopter encountered dynamic rollover, and rolled over on its…NTSB LAX00LA238Accident · No injuriesLimited investigationFinal reportWard Sidewinder · Madera, CAThe pilot's inadequate short field landing procedure and his delayed decision to proceed to an alternate destination, which resulted in fuel exhaustion and a subsequent hard landing during the emergency descent.NTSB LAX00LA237Accident · No injuriesLimited investigationFinal reportCessna 150M · El Monte, CAThe inadequate maintenance inspection by other maintenance personnel of the exhaust system that resulted in an eroded muffler that allowed hot gases to impinge on magneto wiring and resulted in loss of engine power. A factor was the soft terrain at the forced…NTSB FTW00LA183Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Ben Wheeler, TXThe pilot's inadvertent stall of the aircraft.NTSB DEN00LA115Accident · No injuriesLimited investigationFinal reportCessna 172K · Orchard, COThe pilot inadvertently stalling the airplane. A factor was his failure to maintain sufficient airspeed.NTSB ATL00LA065Accident · No injuriesLimited investigationFinal reportBeech 19B · Tampa, FLThe loss of engine power for undetermined reasons. A factor was the weather conditions were favorable for the formation of carburetor ice. Contributing to the severity of the accident was the pilots lack of experience in the airplane which led to an…NTSB ANC00LA073Accident · Minor injuriesLimited investigationFinal reportBlanc Glastar · Northway, AKThe pilot's continued flight into known adverse weather. A factor associated with the accident were low clouds.NTSB ANC00LA072Accident · No injuriesLimited investigationFinal reportCessna 180 · Port Alsworth, AKThe fatigue failure of the left main landing gear leg at the main landing gear axle attachment bolt holes.NTSB LAX00LA235Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Selma, CAThe pilot's inadequate preflight planning that resulted in fuel exhaustion and subsequent collision with grapevines during an off airport forced landing.NTSB ANC00GA071Accident · 4 fatalFinal reportCessna 185E · Talkeetna, AKThe pilot's continued flight into known adverse weather conditions and subsequent in-flight break-up. Factors in the accident were weather conditions consisting of low ceilings, turbulence, and an occluded front with convective activity, and inadequate…NTSB NYC00LA173Accident · No injuriesLimited investigationFinal reportFleet 16B · Rochester, NHThe pilot's failure to maintain directional control. A factor in the accident was the pilot's lack of experience in the accident airplane make and model.NTSB NYC00LA171Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Ventus 2CM · Warren, VTThe pilot's inadequate compensation for crosswind conditions. A factor in the accident was the cross wind.NTSB NYC00LA170Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1 · Nashua, NHThe flight instructor's delayed corrective action.NTSB LAX00LA234Accident · 1 fatalLimited investigationFinal reportBeech G35 · Byron, CAin-flight loss of control and inadvertent stall.