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 SEA04LA090Accident · No injuriesLimited investigationFinal reportBell 206B · Auburn, WALoss of control for undetermined reasons.NTSB NYC04CA129Accident · Minor injuriesData collectionFinal reportGrumman American AA-5 · Greene, RIThe pilots improper decision to depart with the flaps set to 10 degrees, and his failure to obtain proper airspeed, which resulted in a collision with trees.NTSB NYC04CA128Accident · Serious injuriesData collectionFinal reportCameron Balloons N90 · Whately, MAThe pilot's failure to maintain clearance from the trees. A factor was windshear.NTSB LAX04CA231Accident · No injuriesData collectionFinal reportGlenn L Smith RV-8 · Boulder City, NVthe pilot's failure to maintain directional control of the airplane. Contributing to the accident was a sudden wind shift.NTSB FTW04LA148Accident · No injuriesLimited investigationFinal reportBruce Moore Skybolt · Altus, OKThe partial in-flight separation of the wing fabric and rib structure due to an inadequate material installed by the airplane builder.NTSB FTW04LA133Accident · No injuriesLimited investigationFinal reportBell 412 · San Antonio, TXThe pilot's failure to maintain clearance with the parked helicopter while performing a hovering turn.NTSB DEN04FA079Accident · 3 fatalField investigationFinal reportMooney M20K · Pinedale, WYThe pilot's inadvertent flight into adverse weather conditions, and his failure to maintain terrain clearance while maneuvering. Contributing factors were the downdraft, the snow shower weather and mountainous terrain.NTSB ATL04CA121Accident · No injuriesData collectionFinal reportBeech BE-24 · Chamblee, GAThe pilot's failure to use checklist resulted in a gear-up landing.NTSB ANC04LA059Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Goodnews, AKThe pilot's inadequate weather evaluation which resulted in an in-flight encounter with severe turbulence, and his exceedence of the design stress limits resulting in overstress of the wings. A factor contributing to the accident was the presence of…NTSB SEA04LA095Accident · 1 fatalLimited investigationFinal reportWSK PZL Mielec PZL M-18B · Borah Peak, IDThe pilot's inadequate planning/decision, VFR into IMC, and his failure to maintain terrain clearance. Factors include mountainous terrain and instrument meteorological condition.NTSB LAX04CA221Accident · No injuriesData collectionFinal reportAmerican Blimp A-1-50 · North Las Vegas, NVthe ground crew's inability to maintain control of the airship and the pilot's inability to obtain a sufficient rate of climb. Contributing to the accident was unfavorable winds.NTSB IAD04LA022Accident · 1 fatalLimited investigationFinal reportMasak Scimitar · Alexandria, PAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin. A factor was the turbulent wind conditions.NTSB DEN04LA077Accident · No injuriesLimited investigationFinal reportCessna 182E · Santa Teresa, NMthe pilot's inadequate in-flight planning and decision-making, which resulted in the loss of engine power due to fuel exhaustion. Contributing factors to the accident were the fuel exhaustion and the lack of suitable terrain for a forced landing.NTSB DEN04CA073Accident · No injuriesData collectionFinal reportPiper PA-25-235 · Flagler, COthe pilot's improper in-flight planning/decision which led to fuel exhaustion and subsequent loss of engine power. Factors contributing to the accident were the low altitude, low airspeed, and the inoperative fuel quantity gauge.NTSB DEN04CA072Accident · Serious injuriesData collectionFinal reportLindstrand Balloons 180A · Ridgeway, COthe sudden wind gusts and the pilot's failure to maintain control of the balloon resulting in the balloon's basket impacting two vehicles and a house, and subsequently impacting the terrain. Factors relating to the accident were the two vehicles, the house,…NTSB ANC04FA056Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Cold Bay, AKA loss of engine power during the final approach to land for an undetermined reason, and the pilot's failure to maintain airspeed during the ensuing emergency descent, which resulted in an inadvertent stall. A factor associated with the accident was the stall.NTSB LAX04TA218Accident · No injuriesFinal reportEurocopter France AS350 B3 · Livermore, CAThe pilot's failure to maintain clearance from obstructions while landing.NTSB LAX04CA219Accident · No injuriesData collectionFinal reportCessna R172K · Hawthorne, CAthe pilot's misjudged flare and failure to maintain adequate airspeed, resulting in a stall and hard landing. Factors in the accident were the night conditions and the pilot's lack of familiarity in the make and model of airplane.NTSB FTW04LA136Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Brookland, ARThe pilot's failure to maintain clearance with the power lines while maneuvering.NTSB FTW04LA132Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Donna, TXThe pilot's failure to maintain clearance from the high tension power lines.NTSB MIA04FA086Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Venice, FLFailure of the pilot to recover from an improper landing flare resulting in his failure to maintain airspeed (Vs), an inadvertant stall, loss of control, and inflight collision with terrain during an uncontrolled descent.NTSB LAX04LA216Accident · Minor injuriesLimited investigationFinal reportBell 206L-3 · Palmdale, CAThe momentary loss of engine power for undetermined reasons.NTSB LAX04CA217Accident · No injuriesData collectionFinal reportPiper PA-34-200T · Livermore, CAthe pilot's failure to maintain directional control.NTSB FTW04IA134Incident · No injuriesIncident investigationFinal reportBeech A23A · Kress, TXThe in-flight separation of the crankshaft for undetermined reasons.NTSB ANC04LA055Accident · No injuriesLimited investigationFinal reportCessna 185E · King Salmon, AKThe pilot's inadequate compensation for wind conditions during takeoff and initial climb, which resulted in a loss of control, and an in-flight collision with water. A factor contributing to the accident was gusty wind conditions.NTSB SEA04FA088Accident · 1 fatalField investigationFinal reportCessna A185F · Molalla, ORThe pilot's inadequate in-flight planning/decision which resulted in VFR flight into IMC, and his failure to maintain control. Factors include mountain obscuration, clouds and convective weather conditions.NTSB LAX04CA214Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Chandler, AZthe pilot's improper application of brakes during the landing roll, resulting in a nose over.NTSB FTW04LA130Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · San Angelo, TXThe loss of engine power for undetermined reasons. A contributing factor was the soft terrain encountered during the aborted takeoff.NTSB ENG04RA027Incident · No injuriesForeign investigationde Havilland DHC-8-4002 · Sandefjord, NorwayNTSB DCA04WA047Incident · No injuriesForeign investigationBoeing 737 · Iquitos, PeruNTSB CHI04CA122Accident · No injuriesData collectionFinal reportCessna 180J · South St. Paul, MNThe total loss of engine power during takeoff climb due to fuel starvation as a result of the pilot's failure to follow the aircraft's checklist and leaving the fuel selector in the OFF positon.NTSB SEA04LA084Accident · No injuriesLimited investigationFinal reportPiper J4/E · Bigfork, MTA loss of engine power due to fuel exhaustion while in cruise flight as a result of inadequate preflight planning / preparation. Factors contributing to the accident were the short landing field and trees.NTSB DEN04CA076Accident · No injuriesData collectionFinal reportWilford J. Tolman Kitfox 6 · Montrose, COthe pilot's failure to maintain aircraft control during takeoff initial climb. A contributing factor was the gusting left tailwind weather condition.NTSB CHI04WA125Accident · 4 fatalForeign investigationde Havilland DHC-2 MK.1 · Fawcett Lake, CanadaNTSB ATL04IA119Incident · No injuriesIncident investigationFinal reportBeech 200 · Millington, TNThe pilots failure to follow the checklist for emergency landing gear extension resulting in the collapse of the main landing gear on touchdown.NTSB ATL04CA120Accident · No injuriesData collectionFinal reportStinson SR-8E · Peachtree City, GAThe pilot's failure to maintain directional control on landing roll out resulting in a loss of control and ground loop.NTSB SEA04FA083Accident · 1 fatalField investigationFinal reportCessna 170B · Tenino, WAThe pilot's failure to maintain an adequate visual lookout during cruise flight, which resulted in a midair collision between the two airplanes.NTSB NYC04WA126Accident · 1 fatalForeign investigationRobinson R-44 · Ulenurme, EstoniaNTSB MIA04CA085Accident · No injuriesData collectionFinal reportCessna 172N · Pembroke Pines, FLThe pilot's failure to establish a climb and his failure to maintain directional control of the airplane during an aborted landing leading to the airplane departing the runway and incurring substantial damage.NTSB IAD04LA023Accident · No injuriesLimited investigationFinal reportCessna 150 · Old Town, METhe pilot's failure to abort the takeoff. Factors were the pilot's incorrect assessment of the airplane's weight and the muddy terrain.NTSB FTW04WA129Accident · 4 fatalForeign investigationCessna T210J · Rosario, ArgentinaNTSB ATL04FA118Accident · 1 fatalField investigationFinal reportBeech A36 · Morrisville, NCThe failure of the engine for undetermined reasons resulting in the aircraft colliding with powerlines and the ground during the subsequent forced landing.NTSB SEA04LA087Accident · No injuriesLimited investigationFinal reportCessna 185A · Polson, MTThe pilot's inadequate compensation for the changing wind conditions at the time of the landing. Factors include gusty, variable, crosswinds, and a runway marker near the edge of the runway the pilot was landing on.NTSB SEA04LA085Accident · No injuriesLimited investigationFinal reportStinson SR-10E · Eliza Island, WAThe pilot's misjudgment of altitude/distance resulting in an undershoot of the runway.NTSB NYC04LA130Accident · Minor injuriesLimited investigationFinal reportHigh Craft Buccaneer · Glasco, NYThe pilot's failure to maintain airspeed during landing, which resulted in an inadvertent stall and subsequent impact with the water. A factor was the pilot's lack of experience in the airplane and his diverted attention.NTSB MIA04LA084Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Everglades City, FLThe failure of the pilot to maintain airspeed during climb after takeoff resulting in an inadvertent stall, uncontrolled descent, and impact in a wooded area.NTSB LAX04LA213Accident · 4 fatalLimited investigationFinal reportBachman Lancair IV-P · Supai, AZthe loss of aircraft control while in cruise flight for undetermined reasons.NTSB ANC04LA054Accident · No injuriesLimited investigationFinal reportCessna 208B · Egegik, AKThe captain's improper evaluation of the weather conditions and improper decision to taxi the airplane in high gusting wind conditions which resulted in the airplane's right wing striking the ground. A contributing factor was the high gusting wind.NTSB NYC04FA123Accident · 1 fatalField investigationFinal reportCessna 310R · Willoughby, OHThe pilot's failure to maintain aircraft control during the initial climb after takeoff. Factors in this accident were clouds and the night conditions.NTSB LAX04LA211Accident · No injuriesLimited investigationFinal reportCessna T182T · Paulden, AZThe pilot's inadequate compensation for the wind conditions and failure to maintain an adequate airspeed.