NTSB investigations, 2004
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\") = 2004 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") = 2004 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 LAX05LA013Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Mesa, AZthe student pilot's failure to maintain directional control of the airplane during a touch-and-go takeoff.NTSB DEN05LA013Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Glenwood Spring, COthe pilot's failure to use carburetor heat which resulted in the formation of carburetor ice and the loss of engine power. Related factors were conditions conducive for carburetor icing and the lack of suitable terrain for a forced landing.NTSB ATL05LA009Accident · 2 fatalLimited investigationFinal reportNorth American Harvard II T-6 · Leesville, SCLoss of engine power due to fuel system contamination which blocked the flow of fuel which resulted in fuel starvation.NTSB ATL05FA008Accident · 1 fatalField investigationFinal reportBeech F33A · Flat Rock, NCThe pilot experienced spatial disorientation, which resulted in a loss of control and the subsequent collision with the ground. Factors were low ceilings and fog.NTSB SEA05WA012Accident · 1 fatalForeign investigationCessna F-406 · Inverness, United KingdomNTSB MIA05WA010Accident · No injuriesForeign investigationBeech 1900C · Nassau, BahamasNTSB LAX05LA012Accident · No injuriesLimited investigationFinal reportBeech C24R · Cloverdale, CAthe loss of engine power due to fuel starvation from the pilot's inadequate fuel system management and his delay in selecting the fullest fuel tank.NTSB MIA05LA011Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Pompano Beach, FLThe pilot's inadequate in-flight planning/decision, which resulted in fuel exhaustion and the loss of engine power in one engine. Contributing factors were the pilot's inadequate handling of the aircraft following failure of the right engine for his failure…NTSB DEN05FA012Accident · 2 fatalField investigationFinal reportBeech F35 · Chester, ARthe pilot's inadequate planning/decision which resulted in VFR flight into IMC, and his failure to maintain terrain clearance. Contributing factors were the pilot's failure to follow the briefing recommendation, fog, mist, and observation.NTSB CHI05MA011Accident · No injuriesMajor investigationFinal reportBoeing 747-132 · Lake MichiganThe number one engine separated from the airplane during climb due to the uncontained separation of a portion of the second stage turbine disk rim after the second stage turbine vanes contacted the disk. The second stage turbine vanes contacted the second…NTSB CHI05LA013Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Indian River, MILoss of engine power during initial climb after takeoff for undetermined reasons. A contributing factor was the unsuitable terrain for a forced landing encountered by the pilot and the airplane's low altitude at the time engine power was lost.NTSB CHI05LA012Accident · 1 fatalLimited investigationFinal reportCessna 150M · Ashley, NDThe non-instrument rated pilot's continued flight into known adverse weather conditions and his not maintaining aircraft control during cruise flight. Factors present were the night condition and low ceilings.NTSB ATL05LA007Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · Guntersville, ALTotal loss of engine power due to engine oil contamination, engine oil starvation, and multiple connecting rod bearing failures.NTSB MIA05FA008Accident · 3 fatalField investigationFinal reportEurocopter Deutschland BO-105 CBS5 · Santa Rosa Bch, FLThe pilot's spatial disorientation and in-flight loss of control of the helicopter after encountering night instrument meteorological conditions resulting in collision with water during the resultant uncontrolled descent. A factor in the accident was the…NTSB DCA05MA004Accident · 13 fatalClass 1 · MajorFinal reportBritish Aerospace Jetstream 32 · Kirksville, MOthe pilots' failure to follow established procedures and properly conduct a nonprecision instrument approach at night in IMC, including their descent below the minimum descent altitude (MDA) before required visual cues were available (which continued…NTSB ATL05CA015Accident · No injuriesData collectionFinal reportCessna 172SP · West Columbia, SCThe student pilot's improper landing flare, inadequate recovery from a bounced landing and failure to maintain directional control during rollout. A factor was the runway sign.NTSB WAS05WA001Accident · No injuriesForeign investigationCessna 208B · Loiborsoit, TanzaniaNTSB SEA05LA133Accident · 2 fatalLimited investigationFinal reportAero Vodochody Aero. Works L-39C · Hyak, WAThe loss of aircraft control during climb to cruise due to an undetermined flight control malfunction.NTSB SEA05LA001Accident · Minor injuriesLimited investigationFinal reportAviat A-1 · Winifred, MTThe pilot's failure to maintain airspeed which resulted in an aerodynamic stall while maneuvering.NTSB MIA05CA014Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Valkaria, FLThe inadvertent collision with a deer during takeoff which resulted in damage to the right brake system and the airplane being unable to stop prior to the end of the runway.NTSB MIA05CA009Accident · Serious injuriesData collectionFinal reportRobinson R-22 · Vega Baja, PRThe pilot's failure to select a suitable landing area resulting in a tangled skid with vegetation during an aborted landing and subsequent dynamic roll over.NTSB DFW05LA009Accident · No injuriesLimited investigationFinal reportCessna 150L · Denton, TXThe loss of engine power due to the separation of the accessory drive gear bolts, and the failure of the starter-clutch assembly. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DCA05WA001Incident · No injuriesForeign investigationBoeing 757 · ArgentinaNTSB CHI05CA010Accident · No injuriesData collectionFinal reportBeech B-55 · Chesterfield, MOThe diverted attention and the inadequate flare by the pilot during landing.NTSB ATL05FA010Accident · 2 fatalField investigationFinal reportBeech B-55 · Atlanta, GAThe pilot initiated flight into known adverse weather conditions (thunderstorms), which resulted in a loss of control, and subsequent in-flight collision with the ground.NTSB SEA05LA010Accident · No injuriesLimited investigationFinal reportBeech 99A · Billings, MTthe pilot's failure to follow the instrument approach procedure, which resulted in a premature descent below the decision height and subsequent collision with a building.NTSB LAX05FA011Accident · 1 fatalField investigationFinal reportCessna 310K · Kula, HIThe failure of the pilot to maintain adequate clearance from mountainous terrain during cruise flight. A factor in the accident was the dark night lighting conditions.NTSB ENG05RA001Incident · No injuriesForeign investigationBoeing 777 · Saint-Denis, RéunionimportNTSB CHI05CA006Accident · No injuriesData collectionFinal reportPiper PA-28-160 · Altoona, WIThe pilot's inadequate fuel management leading to the fuel starvation in the left tank during the flight's descent. A factor was the impacted power line.NTSB SEA05LA009Accident · Minor injuriesLimited investigationFinal reportCessna A185F · White Bird, IDThe pilot's failure to attain the proper airspeed for takeoff and his improper soft-field takeoff procedure. Factors contributing to the accident included the pilot's improper preflight planning, the fence, and the closed exhaust stack.NTSB NYC05FA006Accident · 1 fatalField investigationFinal reportBeech H50 · Hartwood, VAThe pilot's inadequate preflight preparation, which resulted in an attempted takeoff with full flaps, and subsequent loss of control.NTSB LAX05LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · Pacoima, CAthe pilot's misjudged distance/altitude and inadequate flare that resulted in a hard landing, and a porpoise down the runway. Also causal was the student pilot's improper bounced landing recovery technique.NTSB ATL05LA005Accident · Serious injuriesLimited investigationFinal reportMoody Easy Riser · Augusta, GAThe pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin, and subsequent collision with the ground.NTSB ATL05CA006Accident · No injuriesData collectionFinal reportCessna 177 · Auburn, ALThe pilot's improper landing flare resulting in a hard landing. A factor was the pilot's diverted attention.NTSB ATL05CA004Accident · Serious injuriesData collectionFinal reportLuscombe LL-8 · Jasper, GAThe pilot's excessive braking during landing roll resulted in a nose over.NTSB ANC05LA009Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Chickaloon, AKThe pilot's failure to maintain directional control of the airplane, which resulted in a collision with terrrain during the landing roll. Factors contributing to the accident were a rough/rutted and snow-covered airstrip surface, and an inadvertent ground…NTSB NYC05CA007Accident · No injuriesData collectionFinal reportBeech A23 · New Market, VAA collision with a deer during the takeoff roll. A factor in the accident was the night.NTSB MIA05CA006Accident · No injuriesData collectionFinal reportSchweizer 269C · Diamond Head, MSThe pilot's inadvertent loss of tail rotor effectiveness during takeoff to a hover and aborted landing in a grass area resulting in the grass catching fire from the engine exhaust and the helicopter being consumed by fire.NTSB DFW05LA007Accident · No injuriesLimited investigationFinal reportCessna T210N · Seven Points, TXThe loss of engine power due to the failure of the number one connecting rod. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05CA006Accident · No injuriesData collectionFinal reportGunnoe Velocity · Myrick, OKThe pilot's improper wind evaluation. Contributing factors were the tailwind and the short runway.NTSB CHI05CA007Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Port Austin, MIThe pilot's excessive airspeed during landing resulting in the airplane exiting the end of the wet turf runway. Factors were the wind gusts, the wet grass, the reported airplane braking not being possible on the wet grass, and the impacted fence.NTSB SEA05FA007Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Grand Ronde, ORThe pilot's failure to maintain clearance from high terrain while maneuvering. A factor contributing to the accident was the high terrain.NTSB MIA05WA007Accident · 3 fatalForeign investigationDouglas DC-3C · Medellin, ColombiaNTSB LAX05TA008Accident · No injuriesFinal reportHughes OH-6A · Jacumba, CAthe pilot's failure to maintain adequate clearance from the mountainous terrain, which resulted in the helicopter's tail rotor blades impacting rocks. A factor in the accident was the pilot's complacency.NTSB LAX05LA009Accident · 1 fatalLimited investigationFinal reportBrackett And Peltz Kit Fox III · Aguila, AZthe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in a stall. The nature and scope of the problem reported by the pilot is undetermined.NTSB LAX05LA007Accident · 1 fatalLimited investigationFinal reportDeRosier DR-107 · San Diego, CAthe pilot's failure to maintain adequate clearance from terrain while performing low-level aerobatic maneuvers.NTSB IAD05LA005Accident · No injuriesLimited investigationFinal reportBeech C24R · Hyannis, MAThe mechanic's failure to secure the fuel pressure line to the fuel pressure gauge fitting, which resulted in an engine compartment fire and a subsequent loss of engine power.NTSB DFW05CA008Accident · No injuriesData collectionFinal reportPiper PA-22 · Reserve, LAThe pilot's failure to compensate for the existing wind conditions. A contributing factor was the strong crosswind.NTSB CHI05LA004Accident · 1 fatalLimited investigationFinal reportMalone Vans RV-6A · Joliet, ILThe total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight and inadequate fuel consumption calculations, also causal was the pilot's failure to maintain aircraft control during the forced landing. A factor was the…NTSB ANC05FA008Accident · 1 fatalField investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot's failure to maintain control of the airplane due to spatial disorientation, which resulted in an uncontrolled descent and collision with water during maneuvering flight. Factors contributing to the accident were fog and low ceilings.