NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 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 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 DFW07FA067Accident · 2 fatalField investigationFinal reportCessna 414 · Rocksprings, TXThe pilot's failure to maintain clearance with terrain. Contributing factors were the below approach/landing minimums weather and the drizzle/mist weather conditions.NTSB DEN07FA059Accident · 1 fatalField investigationFinal reportBeech H-18 · Great Bend, KSThe pilot's failure to maintain aircraft control during the missed approach which resulted in an inadvertent stall and impact with terrain. A contributing factor was the icing conditions.NTSB ATL07LA041Accident · No injuriesLimited investigationFinal reportBeech A36 · Brunswick, GAThe pilot's failure to activate the electric fuel pump following a loss of engine power for undetermined reasons.NTSB ATL07FA040Accident · 4 fatalField investigationFinal reportBeech A36 · Hinesville, GAThe pilot's failure to maintain aircraft control resulting in the in-flight breakup of the airplane due to aerodynamic overload. Contributing to the accident were airframe icing and the pilot's impairment by illegal drugs.NTSB SEA07LA062Accident · No injuriesLimited investigationFinal reportCessna 172RG · Daytona Beach, FLThe fracture and failure of the right landing gear actuator, which resulted in a gear collapse during the landing roll.NTSB SEA07FA061Accident · 1 fatalField investigationFinal reportCessna T210R · Rexburg, IDThe loss of engine power due to the contamination of the fuel manifold valve, and the pilot's continued operation of the airplane with known maintenance discrepancies.NTSB MIA07CA048Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Deland, FLThe pilot's failure to maintain directional control during the landing flare, resulting in an in-flight collision with soft terrain, and a collapse of the right main landing gear.NTSB CHI07FA068Accident · Serious injuriesField investigationFinal reportCessna 208B · Alliance, NEThe pilot's descent below minimum descent altitude while on a nonprecision approach. A contributing factor was a low ceiling.NTSB ANC07CA019Accident · No injuriesData collectionFinal reportAero Commander 100 · Manokotak, AKThe pilot's continued VFR cruise flight into instrument meteorological conditions, which resulted in an in-flight collision with terrain. Factors associated with the accident were fog, low ceilings, snow showers, and snow-covered terrain.NTSB SEA07FA051Accident · 3 fatalField investigationFinal reportBeech 200 · Belgrade, MTThe pilot's failure to maintain an adequate altitude and descent rate during a night visual approach. Dark night conditions and mountainous terrain are factors in the accident.NTSB SEA07LA060Accident · 1 fatalLimited investigationFinal reportBrown Pitts S-1 · Incline Vlg, NVThe airplane collided with a frozen lake for undetermined reasons. Contributing to the accident was the pilot's intentional operation of the airplane while impaired by alcohol and the FAA's failure to obtain additional information about the pilot's…NTSB DFW07CA065Accident · No injuriesData collectionFinal reportMcDonnell Douglas 600N · Vicksburg, MSThe loss of engine power due to fuel starvation as result of a fuel transfer check valve stuck in the closed position. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ATL07CA039Accident · No injuriesData collectionFinal reportCessna C150 · Palmetto, GAThe pilot's inadequate compensation for a crosswind during the landing flare, which resulted in a loss of control and an in-flight collision with objects. A factor associated with the accident was a crosswind.NTSB MIA07IA047Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-8-71F · Miami, FLImproper torque of a landing gear lockbolt by company maintenance personnel during landing gear installation.NTSB LAX07WA082Accident · Serious injuriesForeign investigationCirrus SR22 · Sydney, AustraliaNTSB SEA07CA057Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Ontario, ORThe pilot's failure to obtain and maintain an airspeed above Vs after lifting off of a remote gravel airstrip. Factors include the pilot's failure to correctly understand the procedure to use for a soft-field takeoff.NTSB LAX07FA080Accident · 1 fatalField investigationFinal reportMooney M20J · Ranchita, CAThe pilot's failure to maintain terrain clearance during a cruise descent. Contributing to the accident were the dark night lighting conditions and the mountainous terrain.NTSB DFW07CA064Accident · No injuriesData collectionFinal reportBeech F35 · McKinney, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB NYC07FA065Accident · 3 fatalField investigationFinal reportSocata TBM 700 · Dartmouth, MABoth pilots' failure to maintain aircraft control during a missed approach.NTSB LAX07LA079Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Palos Verdes, CAthe failure of both pilots to maintain adequate visual lookout and clearance from each other while maneuvering in close proximity.NTSB DEN07IA058Incident · No injuriesIncident investigationFinal reportBoeing 737-522 · Denver, COThe snowplow driver's failure to follow procedures/directives by crossing an active runway without clearance, resulting in a runway incursion and near collision with an airplane during its landing roll.NTSB CHI07WA065Accident · 2 fatalForeign investigationPiper PA-28-140 · Blackpool, United KingdomNTSB ATL07CA037Accident · No injuriesData collectionFinal reportEurocopter France EC120B · Griffin, GAThe first pilot's failure to maintain directional control of the helicopter during hover in ground effect, and the second pilot's (a certificated flight instructor), delayed remedial action, which resulted in an in-flight collision with the ground. A factor…NTSB MIA07CA046Accident · Minor injuriesData collectionFinal reportC.W Crane T2 · Bunnell, FLThe pilot's inadvertent encounter with adverse weather that resulted in a descent and an impact with terrain.NTSB LAX07WA083Accident · No injuriesForeign investigationBell 407 · Warialda, AustraliaNTSB LAX07LA078Accident · No injuriesLimited investigationFinal reportRepublic RC-3 · Julian, CAThe failure of the propeller to crankshaft attachment bolts due to fatigue. A contributing factor was the improper installation of the propeller assembly by maintenance personnel.NTSB DCA07WA024Accident · 1 fatalForeign investigationCirrus Design SR20 · Greenland, GreenlandNTSB CHI07WA066Accident · Serious injuriesForeign investigationRobinson R44 II · Cambridge, CanadaNTSB CHI07LA063Accident · No injuriesLimited investigationFinal reportRaytheon B200 · Cape Girardeau, MOThe company pilot's poor judgment before and during the flight, including turning the oxygen system ready switch to the OFF position after he conducted the preflight inspection and using an unapproved checklist, which did not provide guidance for a fractured…NTSB CHI07LA062Accident · 2 fatalLimited investigationFinal reportHallburg Amphibian S21D · Grinnell, IAThe inadequate preflight planning/preparation by the pilot in command and the fuel exhaustion during cruise flight. An additional cause was the inadequate forced landing procedure. A contributing factor was the tailwind.NTSB ATL07FA038Accident · 2 fatalField investigationFinal reportCessna 172K · Bessemer, ALThe non-instrument-rated pilot's continued visual flight rules flight into instrument meteorological conditions.NTSB NYC07CA093Accident · No injuriesData collectionFinal reportSchweizer 269C · Plymouth, MAThe student pilot's failure to maintain control of the helicopter during landing, and the flight instructor's delayed remedial action.NTSB LAX07WA084Accident · 3 fatalForeign investigationCessna 172RG · Nadi, FijiNTSB LAX07CA077Accident · Serious injuriesData collectionFinal reportBombardier DHC-8-103 · Kaunakakai, HIan in-flight encounter with clear air turbulence, which resulted in a serious injury to a deadheading crewmember.NTSB CHI07LA064Accident · No injuriesLimited investigationFinal reportCessna 414A · Dickinson, NDThe undetermined failure of the emergency landing gear system and the retraction of the right main landing gear during landing.NTSB ANC07LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Glennallen, AKThe pilot's failure to maintain adequate airspeed to preclude a stall while maneuvering, which resulted in an uncontrolled descent and subsequent collision with terrain. Factors contributing to the accident were variable wind conditions, and an inadvertent…NTSB SEA07LA056Accident · Minor injuriesLimited investigationFinal reportMartin/Harris Harmon Rocket · Troutdale, ORA total loss of power for undetermined reasons just as the aircraft was maneuvering to enter the downwind for landing. The absence of a suitable landing location was a factor in the accident.NTSB NYC07LA061Accident · No injuriesLimited investigationFinal reportCessna 310Q · Atlantic City, NJThe inoperative safe gear indicator light switch. Contributing to the accident was the pilot hand-cranking the landing gear past the physical stop.NTSB ANC07CA017Accident · No injuriesData collectionFinal reportPiper PA-46-500TP · Vero Beach, FLAn in-flight collision with a bird while maneuvering, which resulted in structural damage to the left wing of the airplane.NTSB SEA07LA055Accident · No injuriesLimited investigationFinal reportCessna 421 · Pocatello, IDThe separation of the bolt that attaches the elevator trim tab actuator rod to the elevator trim tab horn, resulting in violent flutter of the elevator, and eventually to the separation of the inboard half of the right elevator.NTSB LAX07CA076Accident · No injuriesData collectionFinal reportCessna 152 · Aptos, CAthe student pilot's becoming lost and disoriented that resulted in an improper in-flight decision to make a precautionary landing in an unsuitable open field.NTSB NYC07CA060Accident · Serious injuriesData collectionFinal reportSchweizer SGS 2-32 · Bath, PAThe pilot's misjudged altitude/distance while on approach, which resulted in an in-flight collision with trees during an off airport landing. A factor in the accident was the loss of lift.NTSB ATL07FA036Accident · 1 fatalField investigationFinal reportCessna T210M · Haddock, GALoss of engine power for undetermined reasons.NTSB DFW07CA059Accident · No injuriesData collectionFinal reportPiper PA-46-310P · Madison, MSThe loss of engine power due to water contamination in the fuel system. A factor was the muddy terrain.NTSB DEN07CA080Accident · No injuriesData collectionFinal reportAviat A-1B · Englwood, COThe pilot's failure to maintain directional control during landing resulting in a ground loop.NTSB DCA08WA049Incident · No injuriesForeign investigationAirbus Industrie A310 · Santa Maria, PortugalNTSB ATL07CA035Accident · No injuriesData collectionFinal reportCirrus Design SR-22 · Siler City, NCThe pilot's failure to perform an aborted landing which resulted in an inflight collision with the runway.NTSB MIA07CA045Accident · No injuriesData collectionFinal reportCessna 172S · Sanford, FLThe inadvertent inflight collision with a bird resulting in damage to the airplane and the pilot having limited control capability.NTSB DFW07LA061Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Fulshear, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB MIA07CA044Accident · Serious injuriesData collectionFinal reportAirborne Windsports Classic · Sebring, FLThe pilot's delay on the runway prior to takeoff that resulted in an encounter with wake turbulence from a landing jet that had to perform a go-around.