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 LAX97LA114Accident · No injuriesLimited investigationFinal reportHoac Austria DV-20 · Galt, CAa disconnect of a fuel line fitting, due to the manufacturer's inadequate design and/or lack of adequate installation procedure for replacement of the fuel filter; which resulted in fuel starvation, loss of engine power, and a forced landing. Soft terrain in…NTSB ANC97LA030Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Dillingham, AKthe pilot's selection of unsuitable terrain for departure, and his inadequate evaluation of the wind conditions. Factors associated with the accident were: a snow/slush covered runway, and a quartering tailwind.NTSB LAX97LA112Accident · Serious injuriesLimited investigationFinal reportBoeing 767-300 · San Francisco, CAan encounter with unforecasted moderate clear air turbulence, while descending over mountainous terrain.NTSB CHI97LA077Accident · No injuriesLimited investigationFinal reportBeech A36 · Matherville, ILa loss of engine as a result of the pilot-in-command's improper positioning of the fuel tank selector. A factor was the rough terrain.NTSB ANC97LA029Accident · No injuriesLimited investigationFinal reportCessna 337C · Golovin, AKthe pilot's continued flight into adverse weather conditions, and failure to maintain sufficient distance/altitude from terrain. Low ceiling, flat light condition, and the ice pressure ridge were related factors.NTSB SEA97LA068Accident · Minor injuriesLimited investigationFinal reportHemingway Varieze · Arlington, WAThe pilot's failure to maintain control of the aircraft. Factors contributing to the accident were the pilot's lack of total experience in the type of aircraft and the gusty wind conditions.NTSB LAX97LA113Accident · No injuriesLimited investigationFinal reportCessna 172M · Petaluma, CAThe pilot's inadequate compensation for the crosswind condition and his failure to maintain directional control.NTSB LAX97LA111Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Palo Alto, CAthe pilot's improper flare and improper recovery from a bounced landing, which resulted in a porpoise and subsequent overload failure of the nose gear.NTSB LAX97LA110Accident · Serious injuriesLimited investigationFinal reportBell 206B · Mountain Spring, NVthe pilot's poor weather evaluation and the decision to continue to attempt to land during forecast adverse weather conditions.NTSB IAD97LA051Accident · No injuriesLimited investigationFinal reportHughes 369HS · Marion, OHUncovering of the fuel tanks outlet, which resulted in fuel starvation and subsequent loss of engine power. A related factor was the unsuitable terrain.NTSB FTW97LA108Accident · No injuriesLimited investigationFinal reportCessna R172K · Brownsville, TXthe pilot's failure to refuel the airplane which resulted in a loss of engine power due to fuel exhaustion.NTSB CHI97IA074Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-311 · Rapid City, SDa missing 'C' clip, which resulted in the master link coming apart, allowing the electric elevator trim chain and cable to become entangled in the elevator trim cables.NTSB LAX97LA106Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Rubidoux, CAthe pilot's inadequate compensation for the existing gusty crosswind condition, and his failure to maintain runway alignment. The gusty crosswind was a related factor.NTSB ATL97LA044Accident · No injuriesLimited investigationFinal reportCessna 150 · Raleigh, NCa loose fuel capd and siphoning of fuel, resulting in fuel exhaustion and a loss of engine power. A factor was the rough terrain in the forced landing field that resulted in the nose over during the landing roll.NTSB ANC97LA078Accident · No injuriesLimited investigationFinal reportCessna 185F · Ketchikan, AKthe pilot allowed an excessive rate of descent to develope during an approach to land, and delayed in initiating a go-around.NTSB ANC97LA028Accident · No injuriesLimited investigationFinal reportCessna 185F · Delta Junction, AKthe pilot's inadequate compensation of wind conditins, and failure to maintain directional control during the takeoff run. The crosswind was a related factor.NTSB SEA97LA062Accident · Serious injuriesLimited investigationFinal reportHall Kitfox · Billings, MTThe pilot-in-command's failure to maintain flying airspeed while executing a downwind turn at low altitude immediately following takeoff.NTSB SEA97LA061Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Morgan, UTDisconnection of the mixture control wire wound cable sheath. A factor was the abrupt, elevated edge of the highway pavement.NTSB LAX97FA108Accident · Minor injuriesField investigationFinal reportBeech H18 · Honolulu, HIloss of aircraft control for undetermined reason(s).NTSB CHI97LA071Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Point Lookout, MOthe student pilot failed to maintain adequate airspeed and encountered a stall. The factors involved were raising the flaps was not performed, directional control was not maintained and recovery from bounced landing was improper.NTSB ANC97LA027Accident · No injuriesLimited investigationFinal reportCessna 207 · Chevak, AKthe pilot's continued VFR flight into instrument meteorological conditions, his misjudgment of distance and altitude during the approach to land, and his failure to attain a proper touchdown point during the landing. A factor relating to the accident was: the…NTSB SEA97LA065Accident · No injuriesLimited investigationFinal reportHughes 269C · Hood River, ORThe pilot-in-command's misjudgment of altitude and airspeed during a turn.NTSB SEA97LA063Accident · No injuriesLimited investigationFinal reportMaule M-5-180 · Jordan Valley, ORfailure of the pilot to maintain directional control of the aircraft, while landing. Factors relating to the accident included: the pilot's improper inflight decision to attempt a descent through what appeared to be a hole in the clouds, his inadvertent…NTSB SEA97LA060Accident · No injuriesLimited investigationFinal reportCessna 172N · Delta, UTThe pilot's failure to adequately compensate for the prevailing wind conditions, and his subsequent failure to maintain directional control during the landing roll. Factors contributing to the accident are a sudden shift in the prevailing wind at the time of…NTSB LAX97FA107Accident · Serious injuriesField investigationFinal reportHughes 369D · Milolii, HIfailure of the tail rotor for undetermined reason(s), resulting in tail rotor imbalance, separation of the tail rotor, and an autorotative landing on rough terrain with high vegetation. The lack of suitable terrain for a forced landing was a related factor.NTSB NYC97LA056Accident · No injuriesLimited investigationFinal reportCessna 150 · Clarksville, MDThe pilot's failure to maintain directional control and failure to abort the takeoff.NTSB MIA97WA086Accident · No injuriesForeign investigationBeech B90 · St. Johns, Antigua & BarbudaNTSB CHI97IA073Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-102 · Romulus, MIa fractured fusion weld in the piston of the roll spoiler servoactuator, which allowed the plug at the base of the piston to separate and jam the piston. A factor relating to the incident was: the inadequate design of the airplane's roll spoiler servoactuator…NTSB CHI97IA072Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-15 · Des Moines, IAthe cross tie relay shorted resulting in a fire in the left main electrical equipment rack.NTSB CHI97FAMS1Accident · 2 fatalMissing aircraftFinal reportCessna T210N · Chicago, ILUndetermined.NTSB ATL97LA043Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Brooksville, FLinadequate supervision by the flight instructor (CFI), and his failure to ensure that adequate airspeed was obtained/maintained, which resulted in a stall and collision with the ground. The crosswind was a related factor.NTSB NYC97LA053Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Nanjemoy, MDthe pilot's inadequate compensate for the wind conditions and failure to maintain adequate obstacle clearance during the initial climb after takeoff. The unfavorable wind condition and proximity of trees were related factors.NTSB MIA97WA085Accident · 5 fatalForeign investigationIsrael Aircraft Industries 1124A · Guatemala City, GuatemalaNTSB IAD97LA050Accident · No injuriesLimited investigationFinal reportCessna 150 · Turner, MELoss of engine power for undetermined reasons. A related factor was the snowbank.NTSB IAD97GA049Accident · Serious injuriesFinal reportEnstrom 280C · Lucasville, OHThe pilot in command failure to maintain rotor rpm.NTSB LAX97WA109Accident · No injuriesForeign investigationPiper PA-28 · Mulege, MexicoNTSB FTW97LA107Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Salida, COThe airplane's performance being exceeded due to the pilot's inadequate preflight planning. Factors were the uphill runway, high density altitude, and the pilot's lack of experience performing takeoffs from a high altitude airport.NTSB FTW97LA105Accident · No injuriesLimited investigationFinal reportPiper PA-36-375 · Danevang, TXThe utility's company failure to notify affected parties of the downed line, and the pilot's failure to maintain clearance with the downed wire. A factor was the downed wire.NTSB LAX97GA105Accident · 1 fatalFinal reportMcDonnell Douglas 369D · Santee, CASpatial disorientation and temporary visual impairment that led to a loss of aircraft control as result of difficulty to light adaptivity. Contributing was the crew coordination and inadequate night flight recurrency training.NTSB IAD97IA048Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-82 · Newark, NJfatigue fracture of the upper lock link, which led to the collapse of the nose gear during landing.NTSB FTW97LA104Accident · Minor injuriesLimited investigationFinal reportCessna 172M · San Antonio, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall. A factor was the pilot's lack of recent experience.NTSB SEA97LA064Accident · No injuriesLimited investigationFinal reportCessna 150J · Price, UTThe flight instructor's failure to ensure that the dual student maintained adequate airspeed.NTSB LAX97LA104Accident · 1 fatalLimited investigationFinal reportPiper PA-18A · Livingston, CAthe pilot's failure to see and avoid power lines. A factor was the pilot's poor judgment in conducting unwarranted low altitude maneuvering.NTSB FTW97LA106Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Rogers, ARthe pilot's improper fuel consumption calculations, which resulted in the loss of engine power, due to fuel exhaustion. A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB FTW97FA103Accident · 5 fatalField investigationFinal reportPiper PA-24-250 · Farmington, NMloss of aircraft control for undetermined reason(s).NTSB DCA97WA029Incident · No injuriesForeign investigationBoeing 737 · Panama City, PanamaNTSB CHI97TA070Accident · No injuriesFinal reportCessna 172 · Oconto, WIthe failure of the pilot to maintain proper runway alignment and thus clearance with the snow drifts during takeoff. A factor was the distance the snow drifts extended past the runway edge.NTSB NYC97LA054Accident · No injuriesLimited investigationFinal reportCessna 208B · Covington, KYThe pilot's failure to maintain the airplane on the ILS glide slope, which resulted in a descent below the glide path, and the inadvertent in-flight collision with a utility pole. Contributing factors were sleet/snow, dark night conditions, and the pole.NTSB LAX97LA103Accident · Minor injuriesLimited investigationFinal reportCessna 172F · San Pablo Bay, CAtotal loss of engine power due to carburetor icing and the pilot's failure to use carburetor heat.NTSB ATL97IA042Incident · No injuriesIncident investigationFinal reportBoeing 727-232 · Atlanta, GAfailure of ground service personnel to properly close the aft cargo door before the airplane departed.