NTSB investigations, 2000
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 NYC00LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Vincentown, NJThe CFI's delay in remedial action after the student pilot lost control of the airplane. A factor in the accident was the CFI's lack of total experience in flight instruction.NTSB MIA00GA083Accident · Serious injuriesFinal reportRockwell OV-10D · Larandia, ColombiaA loss of power in the right engine due to undetermined reasons and the pilot's failure to maintain control of the airplane. Factors in this accident were; the pilot did not perform a weight and balance calculation, (airplane overweight at takeoff); the…NTSB LAX00LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Honolulu, HIThe pilot's improper use of the brakes during the landing rollout. The pilot's self induced pressure and the quartering tailwind were factors in the accident.NTSB LAX00LA092Accident · No injuriesLimited investigationFinal reportLutes Kitfox II · Livermore, CAThe pilot's inadequate compensation for the existing crosswind condition and his failure to maintain runway alignment.NTSB NYC00LA072Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Alton Bay, NHThe pilot's failure to maintain control of the airplane during takeoff which resulted in an inadvertent stall. A factor in the accident was the pilot's inadequate compensation for the wind conditions.NTSB MIA00WA084Accident · 1 fatalForeign investigationMcDonnell Douglas 369E · Grand Turk, Turks & Caicos IslandsNTSB LAX00LA091Accident · Serious injuriesLimited investigationFinal reportIzatt Mitchell U2 · Jean, NVThe pilot's failure to maintain an adequate airspeed, which resulted in an inadvertent stall and spin.NTSB DEN00LA048Accident · Serious injuriesLimited investigationFinal reportBeech M35 · Albuquerque, NMThe pilot inadvertently allowing the airplane to stall. Factors were the missing alternator belt and the resultant total electrical system failure, and the pilot's attention being diverted.NTSB CHI00LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Chesterfield, MOThe pilot failed to maintain directional control during the takeoff portion of a touch and go landing.NTSB ANC00FA024Accident · 6 fatalField investigationFinal reportCessna U206G · Iliamna, AKThe pilot's attempted flight into adverse weather, and his failure to maintain altitude/clearance above the snow-covered tundra. Factors associated with the accident were snow, rain, and whiteout conditions.NTSB MIA00LA082Accident · Minor injuriesLimited investigationFinal reportMooney M-20C · Andrews, NCThe pilot's failure to use carburetor heat in a timely manner while maneuvering in conditions conducive to carburetor icing, resulting in the loss of engine power and collision with trees during the subsequent emergency descent.NTSB MIA00LA081Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Fayette, ALThe pilot's failure to maintain directional and altitude control of the airplane during a ago-around maneuver, resulting in collision with a fence and utility pole.NTSB FTW00FA079Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Frisco, TXThe pilot's failure to maintain clearance with trees during an intentional low altitude flight maneuver.NTSB SEA00WA064Accident · No injuriesForeign investigationCessna 208 · Filitheyo, MaldivesNTSB NYC00LA097Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · Boston, MAIn flight encounter with turbulence.NTSB DEN00LA047Accident · No injuriesLimited investigationFinal reportBeech A36 · Farmington, NMThe student pilot's excessive remedial action (banking to realign the airplane with the runway). Factors were the student pilot flaring the airplane prematurely and failing to maintain directional control, and the flight instructor's inadequate supervision of…NTSB CHI00WA063Accident · No injuriesForeign investigationBoeing B-707 · Tanzania, SudanNTSB CHI00LA068Accident · No injuriesLimited investigationFinal reportBeech A23 · Knox, INthe instructor pilot not performing remedial action on the student's right drift during the flare. Factors were the student not maintaining directional control, the student not maintaining proper centerline alignment, and the snowbank.NTSB MIA00WA080Accident · Minor injuriesForeign investigationBeech D18S · Bimini, BahamasNTSB LAX00LA087Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-301 · Brawley, CAFailure of the engine due to improper installation of the intake and exhaust push rods (components were switched) by unknown maintenance personnel.NTSB LAX00LA086Accident · No injuriesLimited investigationFinal reportRobinson R44 · Palo Alto, CAThe pilot's failure to use carburetor heat, resulting in a loss of engine power, and, his misjudged autorotation approach that resulted in a collision with the ground during the landing flare. Contributing to the accident was the conditions conducive to…NTSB LAX00LA084Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Santa Barbara, CAThe dual student's loss of directional control and the flight instructor's inadequate supervision of the flight.NTSB ANC00LA023Accident · No injuriesLimited investigationFinal reportStirling AIR CAM · Fairbanks, AKThe pilot's improper compensation for wind conditions during the single-engine landing. Factors associated with this accident were the pilot's intentional shut down of the left engine, the right crosswind, the icy runway, and the snow berms on the edge of the…NTSB NYC00WA071Accident · 3 fatalForeign investigationRobinson R-44 · Chorley, United KingdomNTSB DCA00MA023Accident · 88 fatalClass 1 · MajorFinal reportDouglas MD-83 · Port Hueneme, CAA loss of airplane pitch control resulting from the in-flight failure of the horizontal stabilizer trim system jackscrew assembly's acme nut threads. The thread failure was caused by excessive wear resulting from Alaska Airlines' insufficient lubrication of…NTSB SEA00LA041Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Snohomish, WAThe pilot's improper decision to attempt a go-around, then attempt to stop on the wet grass. Factors include variable winds, the pilot's inadequate compensation for the winds conditions, his inadequate recovery from a bounced landing, wet grass along the side…NTSB MIA00LA079Accident · No injuriesLimited investigationFinal reportBeech D50E · Myrtle Beach, SCThe on-ground fire caused by fuel flowing out the fuel vent and near the exhaust of the left engine resulting in the on-ground fire and substantial damage to the airplane. A finding in the investigation was that all four fuel tanks had been filled before the…NTSB CHI00IA087Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC9-32 · Milwaukee, WIthe chafing of the internal water heater wire. A factor was the missing ground strap.NTSB LAX00LA089Accident · Serious injuriesLimited investigationFinal reportRobinson R22B · Hana, Maui, HIThe student's failure to maintain directional control after encountering a tail rotor vortex ring state induced right yaw.NTSB LAX00LA085Accident · No injuriesLimited investigationFinal reportSiai-Marchetti SF260 · Napa, CAFuel exhaustion due to the pilot's inadequate en route fuel consumption calculations.NTSB LAX00LA083Accident · No injuriesLimited investigationFinal reportCessna 152 · Taft, CAThe pilot's misinterpretation of his VOR navigation indicator, which subsequently led to his becoming lost and disoriented while navigating to an alternate airport and resulted in fuel exhaustion. The pilot's failure to obtain either a preflight weather…NTSB DCA00WA022Accident · 169 fatalForeign investigationAirbus Industrie A 310 · Abidjan, Côte d’IvoireNTSB NYC00LA070Accident · No injuriesLimited investigationFinal reportCessna 150 · Wiscasset, METhe pilot's inadequate preflight inspection.NTSB MIA00LA078Accident · No injuriesLimited investigationFinal reportCessna 152 · Kissimmee, FLThe failure of the pilot to obtain winds aloft for the planned cross country flight with a preflight weather briefing and inadequate fuel consumption calculations performed by the pilot resulting in the total loss of engine power due to fuel exhaustion.NTSB LAX00LA081Accident · No injuriesLimited investigationFinal reportCessna 150F · Windsor, CAThe pilot's inadequate preflight planning in that he did not perform a fuel calculation, and his failure to verify the fuel quantity on board the airplane, which resulted in fuel exhaustion and subsequent collision with the ground.NTSB FTW00LA078Accident · No injuriesLimited investigationFinal reportSwearingen SA-227-AT · Fayetteville, ARThe flight crew's failure to extend the landing gear. Contributing factors were the flight crew's non-compliance with the checklist, the pilot-in-command's diverted attention as a result of the loss of instrument approach/runway lighting, the partial failure…NTSB DEN00LA045Accident · Serious injuriesLimited investigationFinal reportBell 212 · Mt Pleasant, UTFailure of the main rotor mast due to fatigue that resulted from inadequate quality assurance during the manufacturing process.NTSB MIA00LA077Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · W. Columbia, SCThe inadequate wording of the NOTAM for failure to identify that the usable width of the runway was reduced and the inadequate snow removal by airport personnel for failure to remove the snow from the runway resulting in the on-ground collision with a snow…NTSB SEA00LA040Accident · Serious injuriesLimited investigationFinal reportCessna 310R · Columbia Falls, MTFailure of the pilot-in-command to follow the prescribed instrument approach missed approach procedure.NTSB MIA00LA076Accident · No injuriesLimited investigationFinal reportCessna 150L · Statesboro, GAThe partial loss of engine power due to undetermined reasons and unsuitable terrain encountered by the pilot-in-command (CFI), during the forced landing.NTSB FTW00LA084Accident · No injuriesLimited investigationFinal reportMitsubishi MU-300 · Dallas, TXThe diminished effectiveness of the anti-skid brake system due to the slush contaminated runway. Factors were the freezing rain encountered during the approach, coupled with a failure of the horizontal stabilizer heat.NTSB FTW00LA077Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Sarita, TXThe failure of the pilot to maintain main rotor rpm, which resulted in a hard landing.NTSB MIA00LA075Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Ocean Reef Club, FLThe failure of the pilot to maintain directional control of the airplane while taxiing after landing resulting in the on-ground collision with high vegetation.NTSB LAX00LA137Accident · No injuriesLimited investigationFinal reportGrumman American AG5B · Oakland, CAThe inadvertent porpoise and improper remedial action of the pilot during the landing attempt.NTSB LAX00LA077Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Five Points, CAThe pilot's inadequate clearance while maneuvering beneath a telephone line.NTSB FTW00LA075Accident · Minor injuriesLimited investigationFinal reportCessna 414 · Oklahoma City, OKThe failure of the pilot to deice the airplane prior to departure.NTSB ANC00LA022Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Ekuk, AKThe pilot's selection of an unsuitable runway for landing. Factors associated with the accident were the inadequate runway maintenance by the runway maintenance personnel, snow berms, and insufficient runway condition information disseminated by the company…NTSB MIA00LA074Accident · No injuriesLimited investigationFinal reportCessna 172N · Lincolnton, GAThe pilot's failure to remove ice from the wings prior to takeoff resulting in the aircraft not climbing after takeoff and colliding with a tree.NTSB FTW00RA076Accident · 5 fatalForeign investigationCessna 404 · Guadalajara, MexicoNTSB FTW00LA074Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Rayville, LAThe loss of engine power due to a crack in the #6 cylinder. A factor was the lack of suitable terrain for the forced landing.