NTSB investigations, 2005
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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\") = 2005 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") = 2005 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 NYC06WA046Accident · 2 fatalForeign investigationMitsubishi MU-2B-36 · Terrace, BC, CanadaNTSB NYC06LA045Accident · Serious injuriesLimited investigationFinal reportBeech 23 · Chaplin, CTA complete loss of engine power due to carburetor ice. A contributing factor was the lack of suitable terrain for the emergency landing.NTSB NYC06IA044Incident · No injuriesIncident investigationFinal reportBoeing 717-200 · Boston, MAWater dilution of the grease, which resulted in the failure of the number 4 wheel bearing.NTSB DEN06LA024Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Peyton, COthe pilot's delay in applying carburetor heat that resulted in the partial loss of engine power due to carburetor ice. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI06WA047Accident · 2 fatalForeign investigationBell 206B · Coupar Angus, United KingdomNTSB CHI06CA050Accident · Minor injuriesData collectionFinal reportElliott Quad City Ultralight Challenger II · California, MOThe pilot's failure to maintain aircraft control due to his failure to comply with procedures/directives, and the inadvertent stall/spin he encountered on his turn to base.NTSB CHI06CA049Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Spirit Lake, IAThe pilot using an unsuitable runway and not maintaining directional control during the landing leading to the nose over on impact with snow. A factor was the snow that remained on the runway after plowing.NTSB CHI06CA048Accident · No injuriesData collectionFinal reportCessna T210M · North Lima, OHThe pilot not maintaining airspeed and directional control during the landing. Factors were the snow covered soft terrain the airplane nosed over on.NTSB CHI06CA046Accident · Minor injuriesData collectionFinal reportCessna 150M · Algona, IAThe pilot's inadvertent flight into unexpected instrument conditions and his visual look out not possible during takeoff leading to the nose over during the emergency landing after takeoff. Factors were the unexpected fog and the dark night conditions.NTSB ANC06CA013Accident · No injuriesData collectionFinal reportPiper PA-18 · Skwentna, AKThe pilot's selection of an unsuitable landing area, which resulted in an on ground collision with trees during the landing roll. Factors associated with the accident were the icy and snow-covered terrain.NTSB LAX06FA063Accident · No injuriesField investigationFinal reportBoeing 747-400 · Los Angeles, CAthe incorrect installation of the inflation valve cores in the number 11 and number 12 wheel assemblies that allowed the tires to be operated in an over deflected condition that resulted in their failure.NTSB CHI06CA059Accident · No injuriesData collectionFinal reportCessna 150F · Poplar Grove, ILThe student pilot's inadequate recovery from the bounced landing, and not maintaining airplane control during the landing.NTSB LAX06CA061Accident · No injuriesData collectionFinal reportBeech A36 · Fallon, NVThe pilot's failure to abort the takeoff. A factor in the accident was the snow covered runway.NTSB LAX06CA060Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Irwindale, CAThe pilot failed to maintain adequate main rotor rpm.NTSB DCA06MA010Accident · 20 fatalClass 1 · MajorFinal reportGrumman G-73T · Miami, FLThe in-flight failure and separation of the right wing during normal flight, which resulted from (1) the failure of the Chalk's Ocean Airways maintenance program to identify and properly repair fatigue cracks in the right wing and (2) the failure of the…NTSB ANC06CA012Accident · No injuriesData collectionFinal reportCessna 208 · Brevig Mission, AKThe pilot's inadequate compensation for crosswind conditions, which resulted in the left wing striking the ground while taxiing. A factor in the accident was a crosswind.NTSB NYC06LA035Accident · No injuriesLimited investigationFinal reportRobinson R44 · Linden, NJA loss of engine power for undetermined reasons.NTSB MIA06LA041Accident · 3 fatalLimited investigationFinal reportCessna 195 · St. Augustine, FLThe loss of engine power during cruise flight for an undetermined reason, which resulted in an emergency descent and ditching. Factors contributing to the survivability of the accident were the low ceilings and rough water.NTSB MIA06LA033Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Opa-Locka, FLThe failure of the pilot-in-command to maintain airspeed following a reported loss of engine power, resulting in a stall/mush, uncontrolled descent, and in-flight collision with terrain. Factors in the accident were the pilot's intentional operation of the…NTSB SEA06LA029Accident · 1 fatalLimited investigationFinal reportPiper PA-28-181 · Butte, MTThe pilot's failure to maintain clearance from the terrain during low-level maneuvering at night. Factors included the pilot’s improper in-flight decision to continue into an area that was forecasted to possibly contain snow, fog, and low ceilings. Additional…NTSB CHI06CA045Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Toronto, OHThe pilot's decision to depart from the snow-covered runway, which resulted in the swerve during takeoff roll and subsequent nose over.NTSB NYC06CA043Accident · No injuriesData collectionFinal reportPiper PA-23-250 · State College, PAThe pilot's failure to maintain directional control during the takeoff run. A factor was the snow-covered runway.NTSB MIA06CA032Accident · No injuriesData collectionFinal reportCessna 172P · Hialeah, FLThe failure of the CFI to perform a go-around following a long landing resulting in overrun, on ground encounter with soft terrain, and subsequent nose over.NTSB MIA06CA031Accident · Minor injuriesData collectionFinal reportCessna 210 · Stuart, FLThe pilot's failure to maintain adequate airspeed during landing which resulted in an inadvertent stall and subsequent collision with terrain.NTSB LAX06FA059Accident · 1 fatalField investigationFinal reportCessna 172S · Hana, HICollision with mountainous terrain for undetermined reasons.NTSB DFW06WA049Accident · Serious injuriesForeign investigationde Havilland DHC-6-300 · Tamarindo, Costa RicaNTSB DFW06LA040Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Columbus, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06IA025Incident · No injuriesIncident investigationFinal reportBoeing 767-300ER · Houston, TXThe captain's failure to maintain clearance from a parked airplane awaiting for a gate. A contributing factor was that taxi procedures were not issued by ground control to advise the captain that the ramp area where he was taxing was designated as a…NTSB LAX06LA058Accident · 1 fatalLimited investigationFinal reportCessna 177RG · Dixon, CAthe pilot's intentional flight at low altitude and failure to maintain obstacle clearance with a high tension static line. The glare from the setting sun was a factor.NTSB DFW06WA068Accident · No injuriesForeign investigationBell 412 · Macae, BrazilNTSB SEA06TA028Accident · Serious injuriesFinal reportAerospatiale SA-319B · Escalante, UTThe pilot's inadequate remedial action when ground resonance was encountered during landing. Contributing factors were the rough/uneven terrain and company inadequate maintenance.NTSB NYC06LA042Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Dunkirk, NYThe Piper Malibu pilot's failure to use the correct radio frequency for traffic advisories, and his selection of the wrong, inactive runway, which resulted in an on-ground collision with another airplane while landing.NTSB DEN06FA023Accident · 1 fatalField investigationFinal reportCessna 172S · Pinon, NMthe pilot's failure to maintain control of the airplane for undetermined reasons.NTSB ATL06LA024Accident · Serious injuriesLimited investigationFinal reportBoeing 727-2S2F · Memphis, TNThe improper towing of the airplane by the tug operator which resulted in the shearing of the towbar shear pin and subsequent collision of the airplane and tug.NTSB LAX06CA057Accident · No injuriesData collectionFinal reportGrafton Rand KR-1 · El Cajon, CAThe pilot's attempt to turn off the runway at an excessive taxi speed.NTSB CHI06CA044Accident · No injuriesData collectionFinal reportMendenhall Lancair 235 · Medina, OHThe pilot's failure to maintain directional control during landing due to an icy runway. Factors to the accident were the ice/snow contaminated runway surface, snow bank, and the pilot's lack of familiarity with the accident airplane.NTSB ATL06CA025Accident · No injuriesData collectionFinal reportCessna 172S · Mobile, ALThe pilot's improper landing flare, which resulted in a hard landing.NTSB ANC06CA011Accident · No injuriesData collectionFinal reportCessna 208B · Newtok, AKThe pilot's inadequate compensation for gusting crosswind conditions, which resulted in the airplane exiting the runway, encountering snow, and the nose gear collapsing. Factors associated with the accident were the gusting wind and the icy runway.NTSB MIA06WA030Accident · No injuriesForeign investigationCessna 172 · Saint-Barthelem, GuadeloupeNTSB MIA06CA029Accident · No injuriesData collectionFinal reportPiper PA-34-200 · Daytona Beach, FLThe flight instructor's inadequate supervision, and the student pilot's improper go-around procedures, which resulted in the airplane's left wing striking the runway.NTSB LAX06FA055Accident · 2 fatalField investigationFinal reportBeech A23 · Mammoth Lakes, CAa loss of engine power for undetermined reasons, and, the failure of the pilot to maintain an adequate airspeed while maneuvering following the loss of power, which resulted in a stall/spin.NTSB SEA06LA026Accident · Serious injuriesLimited investigationFinal reportHitchens EDI 90FT · Chehalis, WAThe pilot's loss of control of the aircraft for undetermined reasons while on a one-half mile straight-in VFR GPS final approach. Factors included his unsuccessful remedial action, and contact with the terrain in an open soft field.NTSB SEA06CA027Accident · Minor injuriesData collectionFinal reportCessna TP206A · Snohomish, WAThe pilot's higher than normal airspeed on landing which resulted in a runway overrun. Contributing factors were the fog and the wet runway surface.NTSB MIA06CA027Accident · No injuriesData collectionFinal reportErcoupe 415C · Wiersdale, FLThe pilot's improper planning and failure to abort the takeoff in sufficient time which resulted in the airplane overrunning the runway and nosing over.NTSB LAX06LA056Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Corona, CAfailure of both pilots to see and avoid each other during traffic pattern operations at a non-towered airport.NTSB CHI06FA043Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Arco, MNThe pilot's inadvertent cruise flight into instrument meteorological conditions, and his failure to maintain control of the aircraft after experiencing spatial disorientation. Factors associated with the accident are the pilot's improper planning/decision…NTSB WAS06RA005Accident · 107 fatalForeign investigationMcDonnell Douglas DC-9-31 · Port Harcourt, NigeriaNTSB MIA06LA028Accident · No injuriesLimited investigationFinal reportMestas Felix R Velocity LWFG-E · Punta Gorda, FLA loss of engine power for undetermined reasons.NTSB LAX06FA054Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Kingsburg, CAThe pilot's in-flight decision to continue VFR flight into instrument meteorological conditions during descent, which resulted in an in-flight collision with trees and terrain. Fog, low ceiling, and obscuration were factors.NTSB LAX06CA062Accident · No injuriesData collectionFinal reportRyan Navion · Los Angeles, CAthe pilot's failure to maintain adequate clearance from a parked vehicle.