NTSB investigations, 2004
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 ANC04LA047Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Minto, AKThe loss of engine power for an undetermined reason, which resulted in a forced landing and an in-flight collision with trees.NTSB DEN04CA067Accident · No injuriesData collectionFinal reportCessna 172N · Lyons, COa loss of engine power due to carburetor icing. Contributing factors were weather conditions conducive to carburetor icing and unsuitable terrain available on which to make a forced landing and the road sign.NTSB CHI04CA110Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta · Shakopee, MNThe dual student's failure to maintain control of the helicopter during hovering flight and the flight instructor's delayed remedial action in order to prevent a loss of control. Contributing factors were the flight instructor's lack of dual instruction…NTSB CHI04CA109Accident · Serious injuriesData collectionFinal reportAeronca 7AC · Flushing, MIThe pilot's failure to maintain airspeed while on final approach, resulting in an inadvertent stall at a low altitude.NTSB ATL04LA100Accident · Minor injuriesLimited investigationFinal reportAlon A2 · Fort Pierce, FLThe loss of engine power due to fuel starvation resulting from a crack in the gascolator bowl.NTSB ATL04FA099Accident · 3 fatalField investigationFinal reportCessna 172N · Moselle, MSThe pilot's failure to maintain clearance and his inadequate visual look-out while maneuvering resulting in an in-flight collision with a radio tower.NTSB ATL04CA091Accident · Minor injuriesData collectionFinal reportPiper PA-28R-200 · Delco, NCThe flight instructor's improper fuel management resulting in a loss of engine power due to fuel starvation. A factor was the flight instructor's failure to use the checklist.NTSB SEA04LA072Accident · No injuriesLimited investigationFinal reportCessna 170B · Nampa, IDThe right seat pilot's failure to maintain directional control during the initial part of the landing roll, and his improper handling of the aircraft (excessive braking) as the aircraft departed the side of the runway. Factors include the pilot's lack of…NTSB ATL04LA097Accident · 1 fatalLimited investigationFinal reportDurr Lancair Legacy · Oakland, TNThe pilot loss control of the airplane when he continued flight into known thunderstorm and convective activity. A factor is insufficient information provided by ATC personnel.NTSB ANC04LA045Accident · Serious injuriesLimited investigationFinal reportArctic S-1B2 · Big Lake, AKThe flight instructor's failure to insure that the carburetor heat was activated by the dual student following a simulated loss of engine power, which resulted in carburetor ice and the actual loss of engine power during a descent. A factor associated with…NTSB LAX04CA193Accident · Minor injuriesData collectionFinal reportRobinson R22B · Long Beach, CAthe pilot's inadequate compensation for gusty wind conditions and failure to maintain control of the helicopter while hovering.NTSB FTW04LA118Accident · No injuriesLimited investigationFinal reportCessna 182U · Boerne, TXThe pilot's inattentive planned approach to land on a runway with obstructions.NTSB CHI04CA108Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Minneapolis, MNThe pilot not verifying the position of the fuel selector prior to the takeoff, resulting in the loss of engine power during initial climb due to fuel starvation. Factors to the accident were the power pole and the trees.NTSB NYC04CA110Accident · No injuriesData collectionFinal reportPiper PA-34-220T · Willoughby, OHThe pilot's improper flare, which resulted in a hard landing. A factor in this accident was the gusty wind conditions associated with thunderstorm activity.NTSB FTW04LA111Accident · Minor injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Holliday, TXThe failure of the upper tail rotor shaft due to excessive misalignment after two hard landings. Also causal was the manufacturer's failure to provide specific maintenance procedures for checking the alignment of the upper tail rotor shaft.NTSB FTW04CA112Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · San Angelo, TXThe pilot's improper preflight performance planning, and his failure to establish a climb. Factors were the high density altitude and crosswind.NTSB DEN04CA066Accident · No injuriesData collectionFinal reportCessna 182K · Durango, COthe pilot's inadequate in-flight planning and decision making. Contributing factors include the crosswind and the crosswind component exceeded.NTSB CHI04FA107Accident · 1 fatalField investigationFinal reportBell 206L-1 · Boonville, INThe pilot's inadequate planning/decision which resulted in his failure to maintain terrain clearance. Contributing factors were the pilot's inadequate preflight planning, his diverted attention, and the dark night conditions.NTSB ANC04IA046Incident · Minor injuriesIncident investigationFinal reportCessna 208 · Kalaupapa, HIAn in-flight encounter with turbulence during cruise flight, which resulted in a minor injury to a passenger. On February 7, 2006, this occurrence was reclassified from an accident to an incident and this narrative was modified.NTSB SEA04WA091Accident · No injuriesForeign investigationCessna 180J · Echo Bay, BC, CanadaNTSB MIA04FA076Accident · 2 fatalField investigationFinal reportCessna 177RG · Tampa, FLImproper maintenance by other maintenance personnel, and the reinstallation of an unserviced magneto during an engine overhaul, which resulted in the magneto malfunctioning, a loss of engine power, and the airplane being ditched into the water.NTSB LAX04LA297Accident · No injuriesLimited investigationFinal reportAviat A-1A · Visalia, CAthe pilot's failure to maintain an adequate airspeed on final approach, which resulted in an inadvertent stall and a hard landing.NTSB FTW04LA113Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Sweetwater, TXThe propeller overspeed for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB NYC04LA109Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Berkley, MAThe pilot's misjudgment of altitude/distance and his failure to maintain adequate clearance from trees while landing. Factors related to the accident were the lack runway displaced threshold markings, the trees located at the end of the runway, and the…NTSB LAX04LA201Accident · No injuriesLimited investigationFinal reportCessna U206A · Lake Havasu, AZThe pilot's misjudged flare during landing, which resulted in a hard landing and structural damage to the firewall.NTSB LAX04LA192Accident · No injuriesLimited investigationFinal reportAeronca Champ 7AC · Hayward, CAthe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control.NTSB LAX04FA190Accident · Serious injuriesField investigationFinal reportPiper PA 28-161 · Holoaloa, HIThe pilot's continued flight into adverse weather conditions that resulted in an in-flight collision with mountainous terrain. Factors in the accident were rising terrain, low clouds and rain, and the pilot's lack of familiarity with the geographic area.NTSB IAD04FA017Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · North Lima, OHThe pilot's failure to maintain a safe altitude clearance from trees. Factors included the night lighting conditions and the pilot's diminished night vision capability.NTSB ATL04FA096Accident · 4 fatalField investigationFinal reportCirrus Design SR20 · Greenwood, SCThe pilot's failure to maintain airspeed during initial climb that resulted in an inadvertent stall and the subsequent collision with trees. A factor was the inadequate preflight planning/preparation when he failed to lower the wing flaps.NTSB ANC04LA041Accident · No injuriesLimited investigationFinal reportChampion 7GC · Wasilla, AKThe flight instructor's inadequate supervision of the student pilot which resulted in a loss of directional control during the takeoff roll, and subsequent collision with a ditch. A factor contributing to the accident was the student pilot's failure to…NTSB MIA04LA074Accident · Minor injuriesLimited investigationFinal reportTerry E. Morris Glasair III · Lakeland, FLThe pilot's failure to maintain airspeed and establish a climb during an attempted go-around which resulted in a stall/mush and collision with terrain. His failure to follow air traffic control instructions is a contributing factor.NTSB LAX04CA189Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Minden, NVthe pilot's inadequate compensation for the gusty wind conditions and failure to maintain directional control of the airplane, resulting in a collision with terrain.NTSB FTW04WA115Accident · No injuriesForeign investigationLearjet 55 · La Romana, Dominican RepublicNTSB DEN04FA064Accident · Minor injuriesField investigationFinal reportCessna 150H · Boulder, COthe failed magneto and the lack of suitable terrain (lake) for a forced landing.NTSB SEA04LA071Accident · Serious injuriesLimited investigationFinal reportKeller Prospector FK1 · Gibbonsville, IDThe pilot's failure to apply carburetor heat in icing conditions which resulted in a loss of engine power while in cruise flight. Factors contributing to the accident are unsuitable terrain for an emergency landing , trees and mountainous terrain.NTSB SEA04LA070Accident · No injuriesLimited investigationFinal reportCessna 195 · Everett, WAThe pilot's failure to maintain directional control of the aircraft as a result of a locked main gear brake during the landing roll. An inadvertent ground loop was a factor.NTSB MIA04CA077Accident · No injuriesData collectionFinal reportCessna 172S · Key West, FLThe pilot's failure to maintain directional control while landing in gusty wind conditions which resulted in the airplane departing the runway and impacting a sign, incurring damage.NTSB LAX04LA194Accident · No injuriesLimited investigationFinal reportCessna 205 · Page, AZthe fatigue fracture and separation of the pilot's control wheel, which resulted in a momentary loss of control and a hard landing.NTSB DEN04IA063Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2B19 · Colorado Spring, COThe failed air conditioning fan by-pass check valve and the subsequent overtemperature of the air conditioning pack.NTSB CHI04CA095Accident · No injuriesData collectionFinal reportBeech C23 · Lake in the Hil, ILThe dual student pilot not maintaining airplane control during the go-around and the flight instructor pilot's inadequate remedial action resulting in the airplane's uncontrolled descent.NTSB NYC04CA108Accident · Serious injuriesData collectionFinal reportAndrews Zenith Tri-Z · Kennedy, NYThe pilot's improper fuel tank selector position which resulted in a loss of engine power due to fuel starvation.NTSB MIA04LA087Accident · No injuriesLimited investigationFinal reportCurtiss-Wright Travel Air 4000 · Port St. Lucie, FLThe pilot's failure to maintain directional control during landing, which resulted in an inadvertent swerve, the right main landing gear wheel separating, and the airplane impacting trees and incurring structural damage.NTSB MIA04LA075Accident · Serious injuriesLimited investigationFinal reportRichard A. Denisar RV-4 · Spring Hill, FLThe pilot's inadequate preflight planning/preparation, which resulted in a loss of engine power during takeoff/initial climb due to fuel contamination, that resulted in a forced landingNTSB FTW04LA110Accident · Minor injuriesLimited investigationFinal reportCessna 175B · Locust Grove, OKThe improper installation of the generator, which resulted in oil starvation. A factor was the unsuitable terrain.NTSB CHI04CA105Accident · Minor injuriesData collectionFinal reportCessna A185E · Hastings, MNThe pilot not verifying the fuel selector valve's position during the preflight leading to the fuel starvation and subsequent loss of engine power during the flight's initial climb.NTSB ANC04LA040Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Copper Center, AKThe pilot's selection of unsuitable terrain for takeoff, and his failure to utilize carburetor heat, which resulted in a loss of engine power during takeoff initial climb, and a subsequent encounter with snow-covered terrain. Factors contributing to the…NTSB MIA04LA072Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5B · Lakeland, FLThe failure of the pilot to maintain directional control of the airplane during the landing roll resulting in the airplane departing the right side of the runway, collapsing the left main landing gear, the left wing striking the ground, and the airplane…NTSB MIA04LA071Accident · Serious injuriesLimited investigationFinal reportBeech Be-300 · Daytona Beach, FLThe pilot's inadequate management of the airplane's fuel system, which resulted in fuel starvation, a loss of engine power, a forced landing, and damage to the airplane during the landing.NTSB FTW04LA109Accident · No injuriesLimited investigationFinal reportSpannagel RV-8A · Borger, TXA partial loss of engine power as a result of inadequate clearance between the journals and bearings.NTSB CHI04CA106Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Columbia, MOThe pilot inadvertently became lost and over flew his destination in cruise flight and selected an unsuitable landing area for his precautionary landing. Factors were the rough/uneven terrain, the barbed wire fence, and the fence post encountered during the…