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 CHI98LA224Accident · 1 fatalLimited investigationFinal reportPiper PA-28-235 · Liberal, KSthe inadvertent stall, the pilot's inadequate preflight planning, which led to performing a takeoff with insufficient distance to clear the utility pole. A factor which contributed to this accident was the utility pole.NTSB LAX98LA212Accident · No injuriesLimited investigationFinal reportNorth American Navion · San Andreas, CAThe pilot's improper reinstallation of the fuel selector valve handle, which led to the selection of the wrong fuel tank and fuel starvation.NTSB IAD98LA075Accident · Minor injuriesLimited investigationFinal reportHoffmann Fisher FP 404 · Louisa, VALoss of engine power for undetermined reasons.NTSB IAD98LA073Accident · No injuriesLimited investigationFinal reportSaab-Scania F-35 Draken · Oceana, VAThe pilot-in-command's inadequate fuel management which led to fuel exhaustion and subsequent loss of engine power. A related factor was the pilot's unfamiliarity with the fuel system.NTSB FTW98LA288Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Casper, WYThe pilot's improper in-flight planning and decision making by selecting an inadequate landing area for an emergency landing when a suitable landing area was available. Factors were fuel exhaustion, inaccurate preflight planning, and lack of recent experience.NTSB FTW98FA283Accident · 1 fatalField investigationFinal reportMontgomery Quickie TRI-Q/200 · Fort Worth, TXThe pilot's failure to maintain aircraft control when an excessive taxispeed resulted in an inadvertent lift-off of the airplane. A factor was the pilot's lack of total experience in the make and model of aircraft.NTSB DCA98WA058Accident · 7 fatalForeign investigationBeech 200 · Côte d’IvoireNTSB CHI98LA223Accident · No injuriesLimited investigationFinal reportRockwell S2-R · Williams, MNthe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB CHI98LA222Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer 164B · Hatton, NDthe delayed abort by the pilot, the overweight condition of the airplane, and the pilot's inadequate preparation prior to takeoff. Factors contributing to this accident were the wet condition of the airstrip, the hopper dump valve not working, and the road…NTSB ANC98LA085Accident · No injuriesLimited investigationFinal reportLockheed L-382G · Huslia, AKThe pilot's failure to maintain proper alignment of the airplane during the landing roll.NTSB SEA98LA110Accident · No injuriesLimited investigationFinal reportAeronca 7-AC · Thompson Falls, MTThe instructor's inadequate remedial action with the application of excessive brake pressure.NTSB LAX98LA213Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Redding, CAThe pilot's excessive use of the brakes while taxiing, allowing the aircraft to nose over.NTSB LAX98FA211Accident · 6 fatalField investigationFinal reportEurocopter AS-350-BA · Mt. Waialeale, HIThe pilot's decision to continue VFR flight into deteriorating weather conditions consisting of lowering ceilings and visibility in mountainous terrain, which resulted in the inadvertent entry into instrument meteorological conditions and a collision with a…NTSB CHI98LA220Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Fargo, NDthe pilot's failure to maintain clearance with the powerline during a swath run. A factor associated with the accident was the powerline.NTSB CHI98LA219Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Mobridge, SDThe pilot's failure to maintain clearance from the power lines. Factors associated with the accident were the power lines, and the separation of the vertical stabilizer and rudder which resulted in the pilot's inability to maintain directional control of the…NTSB CHI98LA217Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Ipswich, SDthe pilot's inadequate evaluation of the weather conditions and his failure to maintain aircraft control which resulted in a stall/mush. Factors associated with the accident were the tailwind condition and the soft terrain.NTSB ATL98GA086Accident · No injuriesFinal reportEctor 305A (L-19) · Morganton, NCThe inflight encounter with a downdraft which led to a stall/mush and an inflight collision with the ground. Factors were the inadequate training in mountain flying and inadequate guidelines provided by the North Carolina Forest Service.NTSB NYC98LA134Accident · No injuriesLimited investigationFinal reportCessna 172 · Westminster, MDthe pilot's misjudgment of distance and speed during the approach/landing, and his delay in initiating a go-around. The quartering tailwind was a related factor.NTSB NYC98LA133Accident · No injuriesLimited investigationFinal reportCessna 170B · Oneonta, NYThe separation of the left rudder cable. A factor was chafing of the cable.NTSB NYC98LA132Accident · Minor injuriesLimited investigationFinal reportExtra Flugzeugbau Flugzeugbau EA260 · Georgia, VTThe pilot's inadequate inflight decision and the loss of engine power due to a blocked vent line. A contributing factor was an unreliable fuel gauge.NTSB LAX98FA210Accident · 1 fatalField investigationFinal reportCessna 152 · Santa Ana, CAThe failure of the pilot-in-command to identify a proper touchdown point on the runway and maintain an appropriate glidepath so as to remain clear of vortex turbulence from the preceding large aircraft. A factor in the accident was the pilot's failure to…NTSB CHI98LA221Accident · No injuriesLimited investigationFinal reportCessna T310R · Wheeling, ILthe pilot's inadequate compensation for the wind conditions which resulted in a lack of directional control of the aircraft. Factors to the accident were the two airport signs and the crosswind.NTSB CHI98LA218Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Park Rapids, MNthe pilot's failure to maintain control of aircraft. Factors were the congested helipad conditions and wind gusts.NTSB MIA99FA050Accident · 2 fatalField investigationFinal reportCessna 172L · Macclenny, FLThe student pilot's attempted VFR flight into instrument meteorological conditions, resulting in a subsequent in-flight collision with trees and terrain. Contributing factors were, haze/smoke, the student pilot's failure to obtain a preflight weather…NTSB CHI98LA216Accident · Serious injuriesLimited investigationFinal reportPiper PA-36-375 · Stephen, MNthe visual lookout not being maintained by the pilot. A factor to the accident was the transmission wire.NTSB ATL98LA085Accident · No injuriesLimited investigationFinal reportStroud SKY Bolt · Mocksville, NCThe pilot's loss of directional control during landing roll when the front seat occupant inadvertently got his foot 'jammed' between the strut bungee and the rudder/brake peddle. A factor was the inadequate design of the rudder/brake peddle system.NTSB ANC98LA084Accident · Minor injuriesLimited investigationFinal reportBeech A-35 · Skagway, AKThe pilot's inadequate in-flight planning/decision to ensure the rudder pedals were locked in an operable position.NTSB MIA98FA187Accident · 1 fatalField investigationFinal reportMooney M-20E · Pickens, SCA loss of engine power for undetermined reasons and the pilot not maintaining adequate clearance with objects (trees) during the emergency landing. Contributing factors were the pilot's impairment associated with the use of an antihistamine and the trees.NTSB IAD98FA072Accident · 1 fatalField investigationFinal reportCessna 172M · Hebron, CTThe pilot's failure to obtain a weather briefing which resulted in inadvertent flight into instrument meteorological conditions, and his failure to maintain control of the airplane due to spatial disorientation. Factors in this accident were low ceilings and…NTSB IAD98FA070Accident · 1 fatalField investigationFinal reportCessna 172N · Ocean City, MDThe pilot's failure to maintain control of the aircraft due to spatial disorientation. Contributing factors wer fog, dark night conditions, lack of recent experience, inadequate preflight planning, and flight into known adverse weather.NTSB DCA98WA057Incident · No injuriesForeign investigationBoeing 757-2Y0 · Larnaca, CyprusNTSB CHI98LA214Accident · No injuriesLimited investigationFinal reportCessna 188B · South Haven, MIthe pilot misjudging his distance and not maintaining the proper altitude. A factor was trees.NTSB CHI98LA212Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Rush City, MNthe pilot inadvertently stalled the airplane during the initial takeoff climb. Factors associated with the accident were the pilot's inattentiveness at lowering excessive flaps for takeoff.NTSB ANC98TA083Accident · No injuriesFinal reportPiper PA-18 · Cold Bay, AKThe pilot's inadequate compensation for crosswind conditions. The presence of a crosswind was a factor in the accident.NTSB SEA98FA109Accident · No injuriesField investigationFinal reportNolley BD-5T · Corvallis, ORThe introduction of a fuel containing an ethanol additive into fuel tanks sloshed/sealed with a compound incompatible with alcohols, resulting in debonding of the compound from the fuel tank walls, leading to partial blockage of an in-line fuel filter, and a…NTSB NYC98LA131Accident · No injuriesLimited investigationFinal reportNarrin-Whittman W-8 Tailwind · Germanstown, PAthe pilot's delay in initiating an abort after the wind shifted from a headwind to a tailwind during the takeoff roll. A factor was the sudden windshift.NTSB LAX98LA209Accident · Serious injuriesLimited investigationFinal reportGlaser-Dirks DG-800B · Jean, NVThe disconnection of the elevator control attachment nut due to improper installation by the manufacturer, which resulted in the pilot's loss of control.NTSB IAD98LA071Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Edgemere, MDThe pilot's inadequate in-flight planning/decision which led to fuel exhaustion.NTSB FTW98LA282Accident · No injuriesLimited investigationFinal reportBeech B19 · Frisco, TXThe student pilot's improper landing flare which resulted in a hard larding. Factors were the inadequate supervision of the flight by the flight instructor and the high winds.NTSB FTW98LA278Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Freer, TXThe pilot's failure to maintain tail rotor-ground clearance due to his improper flare while hovering.NTSB CHI98LA215Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Grays Lake, ILthe pilot's not performing a recovery from a bounced landing and his not maintaining directional control. A factor was soft terrain.NTSB CHI98LA211Accident · Minor injuriesLimited investigationFinal reportHartzler Nieuport 11 · Gardner, KSthe pilot's inadequate weather evaluation and the aircraft stall. A factor to the accident was the gusting wind.NTSB CHI98LA210Accident · Minor injuriesLimited investigationFinal reportCessna 180A · Bay City, MIa fatigue failure of the left nose gear caster bolt which resulted in a separation of the nose gear during landing.NTSB ANC98LA080Accident · No injuriesLimited investigationFinal reportCessna 185F · Chitina, AKThe pilot's selection of unsuitable terrain for landing. Factors in the accident were uneven and soft terrain on the landing strip.NTSB SEA98LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Manzanita, ORThe pilot's failure to maintain directional control during the aborted takeoff. Factors include a crosswind gust during the takeoff roll.NTSB SEA98LA107Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Murphy, IDThe pilot's decision to initiate an aborted landing at an airport where, due to the high density altitude, his aircraft was unable to outclimb the rising terrain that surrounded airport. Factors include a high density altitude and crosswinds.NTSB NYC98LA198Accident · No injuriesLimited investigationFinal reportCessna CE-500 · Fishers Island, NYAn intermittent short in the right wheel anti-skid system which caused a loss of braking and subsequent overrun.NTSB NYC98LA130Accident · No injuriesLimited investigationFinal reportCessna 172R · Milford, NYThe pilot's decision to intentionally fly below wires, which resulted in the collision with trees. A factor in the accident was the soft grass airstrip.NTSB LAX98LA207Accident · Serious injuriesLimited investigationFinal reportNaval Aircraft Factory N3N-3 · Skull Valley, AZThe pilot's failure to maintain control of the aircraft while maneuvering at a low altitude.NTSB LAX98LA206Accident · No injuriesLimited investigationFinal reportCessna 182 · Markleeville, CAThe failure of the pilot to maintain control of the aircraft on the landing roll. A factor is the pilot's neglect to lower the flaps and reduce his speed prior to landing.