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 LAX00TA163Accident · Minor injuriesFinal reportHughes OH-6A · Green Valley, AZCompany maintenance personnel's failure to secure an attachment nut to a control link. While maneuvering, the parts separated and resulted in the total cyclic control system failure and impact into rough terrain.NTSB LAX00LA164Accident · No injuriesLimited investigationFinal reportCessna U206G · Parker, AZThe failure of the pilot to obtain the proper airspeed during landing, which resulted in a hard landing and subsequent porpoise down the runway.NTSB LAX00LA162Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164B · Lodi, CAA loss of engine power for undetermined reasons.NTSB FTW00LA129Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-D · Lindsay, TXThe student pilot's inadequate compensation for wind conditions. A factor was the downdraft wind condition.NTSB ATL00LA044Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Colquitt, GAA loss of engine power for undetermined reasons.NTSB ATL00LA043Accident · No injuriesLimited investigationFinal reportHiller UH-12ET · Stonesboro, SCThe pilot's improper inflight decision not to refuel which resulted in fuel exhaustion and a total loss of engine power.NTSB MIA00WA188Accident · 3 fatalForeign investigationCessna 150J · Epping Essex, RussiaNTSB LAX00LA161Accident · No injuriesLimited investigationFinal reportCessna 152 · Eureka, CAThe pilot's failure to compensate for a crosswind and to maintain directional control during landing.NTSB FTW00LA127Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Tomball, TXEngine seizure due to the rupture of an oil cooler line.NTSB DCA00WA040Accident · 131 fatalForeign investigationBoeing 737-200 · Samal Island, PhilippinesNTSB CHI00LA116Accident · No injuriesLimited investigationFinal reportBeech 58 · Decatur, ILthe failure of the pilot to extend the landing gear which resulted in the gear-up landing. A factor to the accident was the pilot's failure to complete the landing checklist.NTSB ATL00LA042Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Rock Hill, SCThe maintenance personnel's failure to re-torque the engine driven fuel pump in accordance with an Airworthiness Directive that resulted in a fuel leak and a subsequent engine fire.NTSB LAX00FA160Accident · Serious injuriesField investigationFinal reportBell 206L-3 · Grand Canyon, AZA snow ingestion caused loss of engine power due to the pilot's inadequate preflight inspection and failure to remove the accumulated snow from the engine inlet area. Also causal was the pilot's failure to maintain main rotor rpm while maneuvering to avoid…NTSB DEN00FA074Accident · No injuriesField investigationFinal reportBell 206L-3 · Lakewood, COThe complete loss of the tail rotor blades due to a fatigue failure of one blade. Factors were sloping and rough uneven terrain for the ensuing forced landing.NTSB DCA00WA042Incident · No injuriesForeign investigationBoeing 737-400 · Brisbane, AustraliaNTSB CHI00LA115Accident · No injuriesLimited investigationFinal reportCessna 172R · Battle Creek, MIthe student pilot's failure to maintain directional control of the airplane during the landing. Factors associated with the accident were the misjudged landing flare, the student's lack of total experience, the runway lights, and the runway signs.NTSB ANC00LA048Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Big Lake, AKThe pilot's excessive application of heel brakes. A factor associated with this accident was the pilot's lack of experience in the make and model of airplane.NTSB LAX00LA157Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Yreka, CAthe total loss of engine power while in cruise flight due to the fatigue failure of the engine's anti-ice bleed air line, which resulted in the pilot's inability to utilize the engine anti-ice system. Contributing factors were the icing conditions and the…NTSB LAX00GA158Accident · 3 fatalFinal reportGrumman US-2C · Reno, NVthe flying pilot's failure to maintain directional control following a loss of engine power. Also causal was the failure of the flight crew to follow the published checklist and use the rudder assist system, and the decision not to abort the takeoff.NTSB LAX00FA159Accident · Serious injuriesField investigationFinal reportConvair BT-13A · Pearl Harbor, HIthe pilot's failure to anticipate turbulence from the formation lead airplane. Contributing to the accident was the pilot's failure to maintain control of the airplane.NTSB IAD00FA038Accident · 1 fatalField investigationFinal reportPiper PA-12 · Norfolk, MAThe loss of power for undetermined reasons, which resulted in an inadvertent stall during at banner pick-up.NTSB FTW00RA128Accident · 7 fatalForeign investigationCessna TU206F · Nevaj, GuatemalaNTSB SEA00FA074Accident · 1 fatalField investigationFinal reportMaule M-5-210C · Babb, MTTerrain clearance was not maintained. High mountains, mountain obscuration, and the pilot's inadequate preflight planning/preparation were factors.NTSB MIA00LA136Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Immokalee, FLthe pilot misjudged the flare resulting in a hard landing short of the intended landing site, subsequently impacting the ground, and nosing over.NTSB MIA00LA135Accident · No injuriesLimited investigationFinal reportHughes OH-6A · Athens, GAthe pilot's failure to maintain control of the helicopter resulting in his misjudging the flare and a subsequent hard landing. Factors in this accident were, the pilot's inadequate planned approach in trail of two heavier helicopters, a crosswind landing…NTSB LAX00LA156Accident · No injuriesLimited investigationFinal reportBell 407 · Grand Canyon, AZThe failure and subsequent disintegration of the oil cooler fan forward hanger bearing.NTSB IAD00LA037Accident · Minor injuriesLimited investigationFinal reportGreenleaf Exec 162F · Manassas, VAWas the pilot' use of an unsecured ballast weight in the cockpit that shifted in flight and blocked the collective control movement.NTSB FTW00LA124Accident · No injuriesLimited investigationFinal reportLuscombe 8C · Galveston, TXThe pilot's inadequate preflight inspection, which resulted in the pilot attempting to takeoff with the elevator and ailerons locked by the passenger side seatbelt.NTSB ANC00LA047Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Delta Junction, AKThe pilot's failure to maintain altitude/clearance. Factors associated with the accident were flat light conditions, and snow-covered terrain.NTSB NYC00LA114Accident · No injuriesLimited investigationFinal reportLoomis Sidewinder · Cincinnati, OHA partial power loss for undetermined reasons.NTSB NYC00LA113Accident · 1 fatalLimited investigationFinal reportPiper J3C-65 · Lanconia, NHThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall.NTSB MIA00LA143Accident · No injuriesLimited investigationFinal reportNew Standard D-25 · Lakeland, FLthe pilot's improper inflight planning/decision to land long, with a tailwind, on a wet grass runway that resulted in the loss of control and the airplane exiting the runway, incurring substantial damage.NTSB MIA00LA134Accident · Minor injuriesLimited investigationFinal reportHiller UH-12C · Lakeland, FLThe disconnection of the tail rotor drive shaft and subsequent lack of tail rotor control. Contributing factors were the worn drive shaft splines and the pilots' failure to apply collective on the touchdown resulting in a hard landing and subsequent roll over.NTSB LAX00LA155Accident · Minor injuriesLimited investigationFinal reportSmith RV-4 · Willows, CADisconnection of the elevator push rod due to the owner/builder's improper installation of the rear jam nut on the elevator pushrod.NTSB FTW00RA126Accident · No injuriesForeign investigationLockheed L-1011-385 · Guayaquil, EcuadorNTSB FTW00LA125Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Arlington, TXThe failure of the pilot to maintain directional control during the landing roll. A factor was the pilot's total lack of experience in tailwheel airplanes.NTSB CHI00LA114Accident · No injuriesLimited investigationFinal reportCessna 404 · Lansing, MIA loss of engine power due to improper fuel. Also causal was the improper aircraft service by the fixed base operator personnel and the unsuitable terrain for the forced landing encountered by the pilot. Factors were the improper grade of fuel and the lack of…NTSB CHI00LA113Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Near Muskegon, MIthe pilot failed to maintain altitude after inadvertently flying to instrument meteorological conditions. Factors associated with the accident were the low ceilings and visibility, the pilot became disoriented after inadvertently flying into IMC, and the…NTSB CHI00LA112Accident · Minor injuriesLimited investigationFinal reportNorth American T-28B · Kankakee, ILthe misjudged glidepath by the pilot. Factors were the failure of the impeller seal resulting in a total loss of engine oil and subsequent engine failure, the plowed farm field, and the lack of suitable terrain for the forced landing.NTSB ATL00FA041Accident · 1 fatalField investigationFinal reportBeech BE-58 · Palatka, FLThe pilot's physically impaired condition due to his high level of alcohol. Factors were the pilot's intentional VFR flight into IMC conditions and failure to perform a missed approach, which resulted in a collision with the ground.NTSB ANC00LA046Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Anchorage, AKThe pilot's selection of an unsuitable landing area. A factor associated with the accident was a frozen puddle.NTSB SEA00LA073Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Acequia, IDThe pilot's failure to obtain/maintain adequate clearance with the irrigation system during initial climb. A contributing factor was the irrigation pivot.NTSB NYC00FA112Accident · 1 fatalField investigationFinal reportCessna 172H · Grottoes, VAThe pilot's loss of control of the airplane in instrument meteorological conditions, which resulted in an inadvertent stall/spin. Factors included the pilot's lack of instrument time under actual conditions, and his lack of recent instrument flight experience.NTSB LAX00LA154Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Palo Alto, CAThe loss of engine power for undetermined reasons during takeoff climb.NTSB CHI00FA111Accident · No injuriesField investigationFinal reportBell 222U · St. Paul, MNThe loss of clamp-up force between the transmission case and the pylon mounted actuator support assembly which resulted in fatigue failure of the threaded studs and dowel pins, the failure of the flight control system, helicopter control not being possible…NTSB ANC00LA045Accident · No injuriesLimited investigationFinal reportCessna 150M · Chickaloon, AKThe pilot's selection of an unsuitable landing area. Factors associated with the accident were an open service door, and snow-covered terrain.NTSB SEA00LA071Accident · No injuriesLimited investigationFinal reportCessna 150H · Lopez Island, WAProper touchdown point not attained by the pilot. Factors include excessive speed at touchdown, a wet runway, a fence, and the pilot's inadvertent flight into IMC.NTSB MIA00LA133Accident · 1 fatalLimited investigationFinal reportAir & Space. 18A · Lakeland, FLThe pilot's in-flight loss of control while maneuvering for undetermined reasons resulting in an uncontrolled descent and subsequent in-flight collision with terrain.NTSB MIA00LA132Accident · Serious injuriesLimited investigationFinal reportHartline Glastar · Woodstock, ALa total engine failure for undetermined reason, resulting in a forced landing and subsequent impact with a tree.NTSB MIA00LA131Accident · Minor injuriesLimited investigationFinal reportMcCan Velox REV II · Mulberry, FLThe bending overstress separation of the elevator pitch control rod for undetermined reasons. This resulted in an in-flight loss of control, bail out, and subsequent in-flight collision with terrain.