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 MIA00LA154Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Highlands, NCTotal loss of engine power due to the obstruction (insect larva) of the left wing aft fuel system line resulting in a forced landing to non suitable terrain.NTSB MIA00LA153Accident · 2 fatalLimited investigationFinal reportMclarty Vans RV-4 · Apex, NCThe loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed resulting in an inadvertent stall and subsequent collision with terrain.NTSB CHI00LA137Accident · No injuriesLimited investigationFinal reportWeatherly 201C · Ionia, KSthe partial engine failure for undetermined reasons and the unsuitable terrain for landing encountered by the pilot. A factor to the accident was the hilly terrain condition.NTSB CHI00LA136Accident · Serious injuriesLimited investigationFinal reportBeech A23-19 · Holmen, WIthe pilot's failure to maintain directional control of the airplane during the landing. Factors associated with the accident were the crosswind, along with the runway light, windsock, garden, and swimming pool that the airplane contacted.NTSB NYC00LA135Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Wellington, OHThe pilot's failure to maintain aircraft control. A factor was the pilot's improper in-flight decision to abort the initial climb due to an open canopy.NTSB NYC00LA134Accident · 1 fatalLimited investigationFinal reportHing FLY Baby 1A · Keymar, MDAn overload failure of both flying wires, on the underside of the right wing, while the airplane was climbing, due to improper balance between the two flying wires, by unknown person(s).NTSB NYC00LA133Accident · Serious injuriesLimited investigationFinal reportPiper PA18-150 · Forest Hill, MDThe pilot's failure to maintain directional control while landing. Factors in this accident were the tailwind condition, and the pilot's lack of flight experience in tail-wheeled airplanes.NTSB NYC00LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Moneta, VALoss of power for undetermined reasons.NTSB LAX00LA196Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Casa Grande, AZThe student pilot's inadvertant movement of the fuel selector to the "off" positon when selecting the alternate tank, and the flight instructor's lack of verification that the fuel selector was in the proper position during the emergency procedure checklist.…NTSB FTW00LA148Accident · No injuriesLimited investigationFinal reportCessna 172H · Mesquite, TXThe flight instructor's inadequate supervision of the student pilot during the landing.NTSB DEN00LA088Accident · No injuriesLimited investigationFinal reportBeech V35B · Erie, COInadvertent cut off of the mixture by the pilot. Factors were: The passenger door opening, the pilot's inexperience in make and model, and rough, uneven terrain in the landing area.NTSB DEN00LA087Accident · No injuriesLimited investigationFinal reportCessna 170B · Bedford, WYThe pilot's inadvertent ground loop. A factor was the soft grass airstrip.NTSB CHI00LA135Accident · 1 fatalLimited investigationFinal reportRotorway Exec 162F · Ithaca, MIthe door separation for undetermined reasons and the foreign object damage due to the door impact to the tailboom and tail rotor drive system.NTSB ANC00LA058Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Big Lake, AKThe pilot's selection of an unsuitable taxi area, and excessive taxi speed. A factor associated with this accident was a ditch in the taxi area.NTSB MIA00LA152Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Fernandina Bch, FLThe loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed resulting in an inadvertent stall., in-flight collision with terrain, and subsequent nose over.NTSB FTW00FA146Accident · 6 fatalField investigationFinal reportBeech BE-95-B55 · Houston, TXthe loss of control on takeoff as a result of the pilot's failure to remove the flight control lock due to his inadequate preflight inspection. A contributing factor was the pilot exceeding the aircraft's certificated maximum weight and balance limitations.NTSB DCA00WA049Incident · No injuriesForeign investigationBoeing 747-200 · IrelandNTSB MIA00LA151Accident · No injuriesLimited investigationFinal reportMooney M20C · Bryson City, NCThe pilot's failure to maintain directional control on landing rollout with a known quartering crosswind, resulting in an on-ground collision with a known fixed object (wooden pallet.)NTSB MIA00LA150Accident · No injuriesLimited investigationFinal reportCessna 172H · Picayune, MSAn in-flight fire in the vicinity of the firewall from an undetermined source. This resulted in a forced landing to an airport and total consumption of the airplane by fire after landing.NTSB LAX00LA195Accident · No injuriesLimited investigationFinal reportEurocopter AS350B2 · Mesa, AZthe instructor pilot's failure to maintain control of the helicopter.NTSB LAX00LA193Accident · Minor injuriesLimited investigationFinal reportSikorsky S61A · Eureka, CAthe loss of power in all engines due to the pilot's inadequate in-flight decision to continue flight with fuel level below the landing minimums specified in the flight manual, which resulted in the unporting of the fuel supply line and fuel starvation. A…NTSB LAX00FA191Accident · 6 fatalField investigationFinal reportRockwell NA-265-65 · Kaunakakai, HIInadequate crew coordination led to the captain's decision to discontinue the instrument approach procedure and initiate a maneuvering descent solely by visual references at night in an area of mountainous terrain. The crew failed to review the instrument…NTSB DCA00WA048Incident · No injuriesForeign investigationDouglas MD87 · NorwayNTSB CHI00LA134Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Ham Lake, MNcarburetor ice. Factors relating to this accident were the icing conditions, the pilot's attempted emergency landing and the low altitude.NTSB CHI00LA133Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Galesburg, NDthe pilot misjudged the landing flare which resulted in a hard landing.NTSB ANC00LA057Accident · No injuriesLimited investigationFinal reportCessna 180K · Anchorage, AKThe pilot's inadvertent ground loop/swerve during landing.NTSB NYC00IA131Incident · No injuriesIncident investigationFinal reportBeech BE-58 · Windsor Locks, CTInadequate screw length information provided by the manufacturer, which allowed an inadvertent installation of a holding screw that was too long, and the subsequent fracture of the switch/circuit breaker. Factors included a short circuit of the beacon motor,…NTSB MIA00LA149Accident · 2 fatalLimited investigationFinal reportMorphew Pitts Model 12 · New Smyrna Bch, FLthe pilot's loss of control in flight for undetermined reasons.NTSB LAX00LA192Accident · No injuriesLimited investigationFinal reportLockheed L1011-385-1 · Maui, HIThe captain's failure to maintain the proper wind-adjusted Vref airspeed, by a margin which varied from 7 to 20 knots too slow, during the final 10 seconds of the approach prior to touchdown.NTSB LAX00LA189Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Marana, AZthe pilot's failure to refuel the airplane as required by the airplane's published flight manual resulting in a loss of engine power due to fuel starvation.NTSB LAX00LA188Accident · No injuriesLimited investigationFinal reportCessna 310Q · Mesa, AZthe overload fracture and separation of the right main landing gear attachment.NTSB FTW00LA145Accident · No injuriesLimited investigationFinal reportBell 47G · San Antonio, TXThe improper touchdown performed by the flight instructor.NTSB ATL00LA056Accident · Serious injuriesLimited investigationFinal reportCessna 210A · Fayetteville, NCThe pilot's improper fuel management resulting in fuel starvation. A factor was improper planned approach.NTSB ATL00LA055Accident · Minor injuriesLimited investigationFinal reportJackson Velocity RG · Kennesaw, GAA separation of the lower engine cowling and subsequent partial separation of propeller blades during a low high-speed pass. A factor was the recent maintenance work performed by the owner/pilot mechanic.NTSB ANC00FA056Accident · No injuriesField investigationFinal reportBeech B24R · Anchorage, AKA fatigue failure of the crankcase through bolt, the separation of number 3 cylinder assembly, and the inadequate maintenance/service of the airplane by company maintenance personnel.NTSB SEA00WA086Accident · No injuriesForeign investigationBell 430 · Chiu An, TaiwanNTSB LAX00TA186Accident · No injuriesFinal reportMcDonnell Douglas 500N · Los Angeles, CAThe combined failure of the operator management and the check pilot to ensure the landing area was suitable for the slide on landing. Factors were the high vegetation that entangled the skids, resulting in the abrupt stop and nose down movement of the…NTSB FTW00RA147Accident · 3 fatalForeign investigationPiper PA-23-250F · Santa Cruz, BoliviaNTSB FTW00FA144Accident · 2 fatalField investigationFinal reportCessna 210L · Mack, COThe pilot's continued VFR flight into instrument meteorological conditions. Factors were the mountain obscuration and the rising terrain.NTSB ANC00LA054Accident · No injuriesLimited investigationFinal reportCessna 170B · Delta Junction, AKA loss of engine power due to an undetermined reason. A factor in the accident was unsuitable terrain for a forced landing.NTSB SEA00LA084Accident · No injuriesLimited investigationFinal reportOveross Vans RV-8 · Independence, ORThe rotation of the right fuel tank elbow fitting within the tank during previous maintenance. The improper alignment resulted in the fuel pick-up tube being mis-positioned and a subsequent starvation of fuel to the engine. Contributing factors were the…NTSB NYC00LA130Accident · Minor injuriesLimited investigationFinal reportLudeman HP-18 · Kutztown, PAThe pilot's failure to maintain control of the glider. A factor related to the accident was the pilot's lack of experience in make and model.NTSB NYC00FA127Accident · Serious injuriesField investigationFinal reportEurocopter BK-117-A4 · Cincinnati, OHthe pilot's misjudgment of his closure rate, while turning to land on the rooftop helipad, which resulted in a collision with the building. Factors in the accident were the tailwind and the stuck windsock.NTSB MIA00FA146Accident · No injuriesField investigationFinal reportBeech F35 · Jackson, MSimproper rigging of the rudder/elevators and differential mechanism assembly by unknown person(s), which resulting in what the pilot describes as inflight flutter of the tail section, which resulted in damage to the aft empennage area.NTSB LAX00LA187Accident · No injuriesLimited investigationFinal reportFairchild KR-21 · Marana, AZFailure of the pilot to maintain directional control.NTSB LAX00LA184Accident · No injuriesLimited investigationFinal reportMcCoy Glasair III · Burbank, CAThe failure of the pilot to maintain a proper glidepath, which resulted in a collision with a power pole and damage to the landing gear.NTSB LAX00LA183Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Grand Canyon, AZThe pilot's inadequate compensation for a crosswind and his failure to maintain directional control during landing, resulting in the airplane veering off the runway and the subsequent collision with a culvert.NTSB FTW00TA142Accident · 1 fatalFinal reportAir Tractor AT-802A · Fort Stockton, TXThe pilot's failure to maintain clearance with the antenna tower. A factor was the smoke weather condition.NTSB FTW00LA141Accident · Minor injuriesLimited investigationFinal reportCessna R182 · Monument Valley, UTThe pilot's inadequate compensation for wind conditions and his delayed go-around, which resulted in the loss of aircraft control. A factor was the turbulent weather conditions.NTSB ATL00LA054Accident · No injuriesLimited investigationFinal reportSchweizer SGU2-22E · Farmington, NCThe pilot's misjudgment of traffic pattern altitude that resulted in an off-field landing and the subsequent collision with the ground. A factor was rough terrain.