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 CHI00LA096Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec PZL-M-18 · Bucklin, KSthe right main gear brake was binding for an undetermined reason which resulted in the pilot's inability to maintain directional control of the airplane.NTSB ANC00LA038Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Fairbanks, AKThe pilot's misjudgment of distance/altitude, and subsequent undershoot during landing. Factors in the accident were light snow precipitation, flat light conditions, snow-covered terrain, and the absence of a visual approach slope indicator.NTSB NYC00LA110Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Waynesburg, PAThe private pilot's inadequate compensation for wind conditions and the flight instructor's delay in remedial action. A factor in the accident was the gusting wind conditions.NTSB NYC00LA099Accident · No injuriesLimited investigationFinal reportCessna 172 · Sissonville, WVThe pilot's failure to maintain runway alignment during takeoff. A factor in the accident was wind gusts.NTSB NYC00LA098Accident · Serious injuriesLimited investigationFinal reportPiper PA28R-200 · Lehighton, PAThe pilot's inadequate compensation for the crosswind. A factor in this accident was the gusty crosswind condition.NTSB MIA00LA120Accident · No injuriesLimited investigationFinal reportCessna 152 · Edgewater, FLThe partial loss of engine power due to undetermined reasons.NTSB MIA00LA119Accident · Minor injuriesLimited investigationFinal reportBair Helicopters Searey · Kill Devil Hill, NCThe inadvertent stall by the pilot-in-command while on final approach resulting in the uncontrolled descent and in-flight collision with water.NTSB FTW00LA105Accident · No injuriesLimited investigationFinal reportSchweizer 300C · New Ulm, TXThe pilot's inadequate in-flight evaluation of the landing area, which resulted in the separation of the main rotor system as a result of foreign object damage.NTSB FTW00FA103Accident · 1 fatalField investigationFinal reportCessna 525 · Buda, TXthe pilot's inadequate in-flight decision to continue a visual approach in instrument meteorological conditions which resulted in his failure to maintain terrain clearance. Contributing factors were the fog, drizzle, and low ceilings.NTSB DCA00WA031Incident · No injuriesForeign investigationBoeing B747-267B · Jeddah, Saudi ArabiaNTSB LAX00LA135Accident · No injuriesLimited investigationFinal reportCessna 172 · Corona, CAThe pilot's inadequate weather evaluation, and his improper remedial actions that led to a precautionary landing and subsequent attempted takeoff from unsuitable terrain.NTSB FTW00LA106Accident · Minor injuriesLimited investigationFinal reportWard Acro · Beasley, TXThe loss of engine power for an undetermined reason.NTSB DEN00LA065Accident · Serious injuriesLimited investigationFinal reportCessna 182K · Hanksville, UTThe pilot inadvertently allowing the airplane to porpoise after landing hard, and inadvertently stalling the airplane after aborting the landing attempt. Factors were wind gusts, and the pilot failing to reconfigure the airplane (resetting the elevator trim…NTSB DEN00FA067Accident · 1 fatalField investigationFinal reportCessna 152 · Roswell, NMThe pilot's failure to maintain aircraft control and the subsequent inadvertent stall/spin. A factor was the pilot's diverted attention to over flying her residence.NTSB CHI00LA099Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Ft. Leavenworth, KSthe pilot of N51933 did not see and maintain clearance from N9570E. A factor associated with the accident was the pilot of N51933's restricted forward visibility during the landing due to the tailwheel configuration. An additional factor was the pilot of…NTSB CHI00LA098Accident · No injuriesLimited investigationFinal reportCessna 152 · Butler, MOthe certified flight instructor's improper use of the mixture control while demonstrating a simulated loss of engine power which resulted in fuel starvation. A factor associated with the accident was the rough terrain on which the forced landing was made.NTSB CHI00LA097Accident · Serious injuriesLimited investigationFinal reportTaylorcraft DC-65 · Joplin, MOan inadequate rate of climb and the failure to attain clearance with the trees during the aborted landing. Factors associated with the accident were the pilot's failure to attain a proper touchdown point during the landing, the trees which were contacted, and…NTSB NYC00LA102Accident · No injuriesLimited investigationFinal reportCessna 172 · Farmingdale, NJThe pilot's failure to maintain control of the airplane which resulted in an inadvertent stall. A factor in the accident was the pilot's use of excessive nose-down elevator trim.NTSB NYC00IA100Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-88 · Boston, MAthe failure of the ground pushback crew to maintain an adequate clearance from a nearby airplane during pushback.NTSB LAX00LA139Accident · No injuriesLimited investigationFinal reportScovil KR-2 · Tonopah, AZThe fuel control metering unit becoming disengaged and the inadvertent use of the fuel supply during flight.NTSB LAX00FA134Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Rialto, CAThe pilot's in-flight loss of control for undetermined reasons.NTSB IAD00LA028Accident · No injuriesLimited investigationFinal reportBellanca B17-30A · Shenandoah, VAthe pilot's failure to maintain control during landing roll-out. A factor was the pilot's lack of total experience.NTSB FTW00LA107Accident · No injuriesLimited investigationFinal reportCessna 172N · Maud, OKthe loss of engine power while maneuvering as a result of the separation of the exhaust rocker arm retaining stud due to fatigue, which resulted in a precautionary landing.NTSB FTW00LA104Accident · Serious injuriesLimited investigationFinal reportCessna 195A · Roanoke, TXThe pilot's inadequate preflight resulting in loss of engine power due to water and rust contamination of the fuel. A factor was the lack of suitable terrain for the forced landing.NTSB DEN00LA068Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Las Cruces, NMThe pilot's failure to maintain directional control, resulting in an inadvertent ground loop/swerve. Factors were a burnt and unseated intake valve, and the tail wind.NTSB DEN00LA064Accident · Minor injuriesLimited investigationFinal reportJohnson Zodiac CH 601 HDS · West Jordan, UTTotal failure of an oil line fitting, resulting in oil exhaustion and subsequent engine seizure. Factors were the poor fitting installation by the pilot, and unsuitable terrain on which to make a forced landing.NTSB ATL00LA038Accident · No injuriesLimited investigationFinal reportAerospatiale SA315B · Springfield, GAThe pilot's inadequate preflight planning resulting in fuel exhaustion.NTSB FTW00WA136Accident · No injuriesForeign investigationCessna 402B · San Jose, Costa RicaNTSB FTW00WA135Accident · Minor injuriesForeign investigationPiper PA-32RT-300T · Guatemala City, GuatemalaNTSB SEA00LA055Accident · No injuriesLimited investigationFinal reportCessna 180K · Roundup, MTThe pilot's failure to adequately compensate for wind conditions and subsequent loss of control.NTSB SEA00LA054Accident · No injuriesLimited investigationFinal reportCessna 172N · Quincy, WAFailure to maintain terrain clearance. Factors include mountainous/hilly terrain.NTSB MIA00LA116Accident · No injuriesLimited investigationFinal reportStearman A75N1 · Fort Lauderdale, FLThe pilot's failure to maintain directional control after touchdown and the subsequent wing tip strike, ground loop, and runway excursion.NTSB MIA00FA117Accident · 1 fatalField investigationFinal reportCessna 177RG · Columbia, SCThe PIC's inadequate planning and preparation resulting in refueling not being performed and the subsequent fuel exhaustion and forced landing into trees. A factor in the accident was the erratic operation of the right fuel tank quantity indicating system.NTSB FTW00RA111Accident · Serious injuriesForeign investigationHelio 700 · Miazal, EcuadorNTSB FTW00FA101Accident · Minor injuriesField investigationFinal reportSaab 340B · Killeen, TXthe captain's failure to follow standard operating procedure for landing on a contaminated ruway in that he touched down long, which combined with his delayed braking resulted in a runway overrun. Contributing factors were the captain's failure to maintain…NTSB DEN00LA066Accident · No injuriesLimited investigationFinal reportCessna 310C · Cedar City, UTThe failure of the right engine mixture control cable, which prevented the pilot from restarting the engine. Contributing factors were the pilot's failure to follow procedures by not feathering the right propeller, the rough terrain, and the high vegetation.NTSB CHI00LA093Accident · Serious injuriesLimited investigationFinal reportLockwood Eagle II · Marengo, ILThe pilot's failure to maintain aircraft control.NTSB NYC00WA096Accident · 1 fatalForeign investigationRaytheon Corporate Jets C90 · Bursa, TürkiyeNTSB MIA00LA113Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Ocean Springs, MSThe pilot's failure to maintain control of the aircraft while making a forced landing following loss of engine power for undetermined reasons, resulting in the aircraft impacting hard on the runway, bouncing into the air, and colliding with powerlines off the…NTSB FTW00RA102Accident · 6 fatalForeign investigationBell 206L4 · Toluca, MexicoNTSB DCA00WA039Accident · No injuriesForeign investigationBoeing 727-23 · Arequipa, PeruNTSB CHI00LA094Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Hayti, MOthe failure of maintenance personnel to properly install and connect the aileron control rod. Factors were the inadequate annual inspection by maintenance personnel and the aileron control not possible by the pilot.NTSB MIA00LA114Accident · No injuriesLimited investigationFinal reportMckinnis Steen Skybolt · Tuscaloosa, ALa loss of engine power during climb due to fuel starvation which was caused by a fuel leak in the gascolator as a result of improper maintenance by the operator that resulted in the pilot making a forced landing during which the airplane sustained substantial…NTSB LAX00LA131Accident · No injuriesLimited investigationFinal reportPiper PA-31-T1 · Scottsdale, AZThe pilot's failure to ensure that the landing gear was lowered before touchdown.NTSB FTW00LA100Accident · Minor injuriesLimited investigationFinal reportBell 206B3 · Brazos 542The pilot's right turn maneuver during low speed resulting in a loss of tail rotor effectiveness and subsequent loss of control.NTSB DEN00FA063Accident · No injuriesField investigationFinal reportDornier 328-100 · Denver, COuncommanded retraction of the nose and right main landing gears during landing roll for reasons undetermined.NTSB NYC00LA095Accident · No injuriesLimited investigationFinal reportCessna 172 · New Brighton, PAThe pilot's inadequate compensation for the gusty wind conditions. A factor was the windshear encountered on final approach.NTSB NYC00FA094Accident · 1 fatalField investigationFinal reportBeech A23 · Akron, OHThe pilot's improper decision to operate the airplane with known deficiencies. A factor in this accident was the inability of the engine to attain full power for undetermined reasons.NTSB MIA00LA115Accident · Serious injuriesLimited investigationFinal reportBeech 1900 · Miami, FLInadequate visual lookout by the driver of the vehicle.NTSB MIA00LA112Accident · No injuriesLimited investigationFinal reportCessna A188B · Lake Placid, FLThe pilots inadequate visual outlook while performing aerial application resulting in the aircraft colliding with a piece of farm equipment which was parked in the field which caused the right main landing gear to separate and damage to the right wing during…