NTSB investigations, 2005
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\") = 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 IAD05LA116Accident · Minor injuriesLimited investigationFinal reportO'Connor Air Command Elite · Cincinnati, OHThe pilot's improper flare following a partial loss of engine power, which resulted in a hard landing. A factor was the partial loss of engine power for unknown reasons.NTSB DEN05LA123Accident · No injuriesLimited investigationFinal reportForbes Rutan Long EZE · Albuquerque, NMa total electrical failure due to a short in the master relay, causing the main fuse to open. Contributing factors included an inadequate electrical design by the airplane's builder, a low-output alternator, a cement wall, and unsuitable terrain on which to…NTSB DEN05LA121Accident · 1 fatalLimited investigationFinal reportSheel Vans RV-8 · Fort Collins, COthe pilot inadvertently stalling the airplane and descending into the ground. Contributing factors were the pilot's inadequate preflight planning/preparation and his failure to refuel the airplane, resulting in a loss of engine power due to fuel exhaustion.NTSB DEN05CA122Accident · No injuriesData collectionFinal reportStinson L-5G · Gallup, NMan on-ground loss of control due to the flight controls becoming jammed because the pilot failed to properly secure his flight bag.NTSB CHI05LA220Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · New Boston, ILThe loss of engine power due to a cylinder failure and the unsuitable terrain encountered by the pilot during the forced landing.NTSB CHI05LA214Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Marshalltown, IAThe loss of engine power for an undetermined reason. A factor was the corn crop.NTSB CHI05CA215Accident · No injuriesData collectionFinal reportRosner Acro Sport II · Princeton, MNThe airplane nosed over during landing as a result of the pilot's failure to maintain control of the airplane when he applied excessive braking.NTSB CHI05CA172Accident · No injuriesData collectionFinal reportWaco CTO · Shelbyville, ILThe loss of engine power during cruise due to carburetor ice. A factor was conditions conducive to carburetor icing.NTSB ATL05LA140Accident · 2 fatalLimited investigationFinal reportAllegro 2000 · Supply, NCThe instructor pilot's failure to maintain airspeed for unknown reasons, resulting in an aerodynamic stall and subsequent collision with the ground.NTSB NYC05LA129Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Penn Yan, NYThe loss of engine power due to a fatigue fractured pushrod.NTSB MIA05LA146Accident · 1 fatalLimited investigationFinal reportGustafson Easy Eagle · Milton, FLA loss of engine power during initial climb after takeoff for an undetermined reason, which resulted in a forced landing and subsequent in-flight collision with tree-covered terrain.NTSB MIA05LA145Accident · Serious injuriesLimited investigationFinal reportFox Alfred C. Kitfox IV 1200 · Immokalee, FLThe pilot's failure to detect standing water on the grass strip resulting in a nose over during the landing roll.NTSB IAD05LA115Accident · No injuriesLimited investigationFinal reportCessna 182B · East Moriches, NYThe improper installation of the right magneto harness to the magneto housing by unidentified maintenance personnel, which resulted in arcing, significant wear, and a subsequent loss of engine power. Factors in the accident were the pilot's failure to attain…NTSB IAD05CA120Accident · No injuriesData collectionFinal reportCessna 172S · White Plains, NYThe pilot's improper recovery from a bounced landing.NTSB DFW05FA204Accident · 2 fatalField investigationFinal reportGlobe GC-1B · Cypress, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall/spin.NTSB DEN05TA119Accident · Serious injuriesFinal reportHughes 369HS · Albuquerque, NMthe bullet(s), which severed the helicopter's left tail rotor pedal. Contributing factors were the severed anti-torque pedal and the unsuitable terrain for landing.NTSB DEN05CA120Accident · No injuriesData collectionFinal reportCessna 172RG · Fort Collins, COthe pilot's failure to maintain directional control. Contributing factors were the crosswind, the pilot's failure to compensate for the wind conditions --- allowing the airplane to touch down without being properly aligned with the runway --- and the flight…NTSB DCA05RA094Accident · 16 fatalForeign investigationATR ATR-72-202 · Palermo, ItalyNTSB CHI05WA216Accident · 2 fatalForeign investigationCessna A185F · Lake Simcoe, CanadaNTSB CHI05LA213Accident · Serious injuriesLimited investigationFinal reportWeatherly 620-B · Osage, IAThe partial loss of engine power for an undetermined reason. Contributing factors were the wires and the trees.NTSB CHI05CA232Accident · No injuriesData collectionFinal reportLet Blanik L-13 · Blair, NEThe low airspeed by the pilot and the inadequate supervision by the certified flight instructor.NTSB ATL05FA139Accident · 1 fatalField investigationFinal reportBeech BE-D35 · Decatur, ALThe pilot's mismanagement of the fuel supply, which resulted in a loss of engine power due to fuel starvation, and subsequent inadvertent stall/spin during the forced landing.NTSB ATL05CA141Accident · Serious injuriesData collectionFinal reportTherrien Roger Vortex · Lawrenceburg, TNThe pilot's improper landing flair, which resulted in a hard landing.NTSB ATL05CA138Accident · Minor injuriesData collectionFinal reportBeech C24R · Lumberton, NCThe pilot's improper/inadequate evaluation of the weather, which resulted into flight into a thunderstorm.NTSB ANC05LA127Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tyonek, AKThe instructor pilot's inadvertent touchdown during a low pass, and attempted go-around, which resulted in an in-flight collision with terrain, and nose over.NTSB SEA05LA162Accident · 2 fatalLimited investigationFinal reportHarmon/Lance RV-4 · Coolin, IDThe pilot's failure to maintain clearance from trees while maneuvering to base leg for landing. Trees and inadequate in-flight planning were factors.NTSB SEA05LA161Accident · No injuriesLimited investigationFinal reportCessna A185F · Seattle, WALoss of engine power for undetermined reasons.NTSB SEA05FA158Accident · 2 fatalField investigationFinal reportCessna 150M · Renton, WAThe failure of the DHC-2 Beaver pilot to understand air traffic advisory information and the failure of the Cessna pilot to maintain visual separation, resulting in a midair collision. A factor contributing to the accident was the inadequate traffic advisory…NTSB SEA05CA167Accident · No injuriesData collectionFinal reportCessna 150L · Kellogg, IDThe pilot's failure to follow the correct go-around procedure during landing by advancing the power too rapidly and not repositioning the flaps to the required 20 degree position. Factors include a crosswind and high density altitude.NTSB IAD05CA117Accident · Minor injuriesData collectionFinal reportCessna C-172G · Eustis, METhe pilot's failure to maintain clearance from a bush during the aborted landing.NTSB DFW05WA221Accident · 2 fatalForeign investigationRobinson R-44 · Col de Menee, FranceNTSB CHI05LA218Accident · Serious injuriesLimited investigationFinal reportEnstrom 480 · Goshen, INGround resonance experienced by the pilots.NTSB CHI05FA212Accident · Minor injuriesField investigationFinal reportCessna 421C · Wheeling, ILThe pilot's improper in-flight decision to execute a go-around without raising the landing gear and raising the flaps to the full UP position, resulting in low airspeed and the airplane stalling. Contributing factors to the accident included the pilot's…NTSB CHI05CA219Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Watertown, WIThe flightcrew's failure to maintain directional control during landing rollout.NTSB ANC05LA117Accident · No injuriesLimited investigationFinal reportAviat A-1 · Anchorage, AKThe flight instructor's inadequate supervision of the dual student, and his failure to maintain control of the airplane. A factor associated with the accident was the dual student's excessive application of the brakes.NTSB ANC05FA121Accident · 2 fatalField investigationFinal reportBeech V35B · Denali Park, AKThe pilot's failure to maintain altitude/clearance from mountainous terrain while climbing, and his improper in-flight decision making by electing to fly at a low altitude toward rising terrain. A factor associated with the accident was mountainous terrain.NTSB SEA05LA164Accident · 1 fatalLimited investigationFinal reportBurkhart Grob G103 Twin Astir · Driggs, IDThe pilot's failure to maintain aircraft control while maneuvering in the traffic pattern for landing. The pilot's failure to maintain a proper altitude was a factor.NTSB SEA05LA163Accident · No injuriesLimited investigationFinal reportSteele Safari · Leavenworth, WAThe failure of the tail rotor drive shaft during cruise flight. Factors include soft, grassy terrain at the location where the pilot executed the autorotational landing.NTSB SEA05CA159Accident · No injuriesData collectionFinal reportCessna 172M · Hoquiam, WAThe pilot's failure to maintain clearance from a fence. The fence was a factor.NTSB MIA05LA143Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Orlando, FLThe manufacturer's defective wheel brake assembly design and a leaking wheel brake, resulting in an overheated brake assembly and a wheel fire during an aborted takeoff.NTSB MIA05CA144Accident · Minor injuriesData collectionFinal reportGrumman American G-164 · Sabana Grande, PRThe pilot's inadvertent encounter with a downdraft in mountainous terrain resulting in an uncontrolled descent and collision with the terrain.NTSB LAX05CA260Accident · No injuriesData collectionFinal reportMaule M-4-220C · Tucson, AZthe pilot's failure to maintain directional control.NTSB DFW05FA202Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-60 · Parker, COThe pilot’s failure to fly a stabilized instrument approach at night which resulted in controlled flight into terrain. Contributing factors were; the dark night, low clouds, the inadequate design and function of the airport facility’s Minimum Safe Altitude…NTSB DFW05CA201Accident · Minor injuriesData collectionFinal reportSmith Aerostar 601P · Sinton, TXThe pilot's failure to abort the takeoff and the subsequent loss of engine power for undetermined reasons. Contributing factors were the attempted operation of the airplane with known deficiencies in the equipment and the lack of suitable terrain for the…NTSB CHI05LA211Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Buchanan, NDThe pilot failed to maintain obstacle clearance from the power lines. Factors included the glare on the windshield and the power lines.NTSB SEA05CA157Accident · No injuriesData collectionFinal reportGrumman G-164B · Paul, IDThe failure of the pilot to maintain direction control during the landing roll, which resulted in a nose over. Contributing factors included the weeds and the wet, soft terrain..NTSB LAX05LA258Accident · Serious injuriesLimited investigationFinal reportBeech A23 · Rancho Murieta, CAfuel starvation due to the inadequate fuel system management by both pilots. Also causal was the inadequate preflight inspection by both the instructor and student and their failure to verify the fuel quantities in each fuel tank, and, the instructor's…NTSB IAD05LA114Accident · 2 fatalLimited investigationFinal reportConvair BT-13A · Lyme, NHThe pilot's improper fuel management which resulted in an incorrect fuel selector position, fuel starvation, and subsequent loss of engine power. A factor in the accident was the pilot's failure to maintain adequate airspeed and inadvertent stall.NTSB DFW05IA200Incident · No injuriesIncident investigationFinal reportAirbus A320-232 · Denver, COThe captain's failure to maintain sufficient clearance while taxiing to an assigned gate, which resulted in a collision with an airplane that had been pushed back (and holding) from another gate. Also causal was the tug operator's failure to follow published…NTSB NYC05IA128Incident · No injuriesIncident investigationFinal reportBeech 1900D · Rockland, MEA loose elevator attachment, which resulted in a partial elevator binding during takeoff and uncommanded elevator movement during cruise.