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 FTW93FA165Accident · 4 fatalField investigationFinal reportFairchild SA-226T · Santa Fe, NMThe pilot's poorly planned circling approach, and his failure to maintain an adequate altitude. Factors which contributed to the accident were: the dark night and a lack of visual reference.NTSB DEN93FA063Accident · 2 fatalField investigationFinal reportMooney M20E · Westcliffe, COThe pilot's loss of aircraft control as he attempted to turn away from a line of thunderstorms. Factors were thunderstorms and associated turbulence.NTSB BFO93LA097Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Reedsville, PATailwheel landing gear system components failing due to their worn condition resulting in the loss of ground steering capability. A factor in this accident was a gusting crosswind encountered during landing roll.NTSB ANC93IA085Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · King Salmon, AKThe failure of the main gear upper strut assembly due to stress corrosion.NTSB SEA93LA122Accident · No injuriesLimited investigationFinal reportCessna TU206G · Mountain Home, IDCompensation for wind conditions was inadequate. The wind gusts were a factor.NTSB SEA93LA121Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Afton, WYA loss of engine power for an undetermined reason(s).NTSB LAX93IA235Incident · No injuriesIncident investigationFinal reportUS/Lta 138-S · Santa Maria, CAInadequate specifications in the design and manufacture of a rudder control tube rod end bearing by the airship manufacturer.NTSB LAX93FA223Accident · 2 fatalField investigationFinal reportCessna 172N · Lompoc, CAVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain proper altitude (or clearance) from mountainous terrain. Factors relating to the accident were: the low ceiling, fog, drizzle, obscuration, and mountainous…NTSB FTW93LA166Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Mount Vernon, TXThe pilot's inadequate compensation for the crosswind.NTSB FTW93FA163Accident · No injuriesField investigationFinal reportMBB BK 117 A-4 · Lafayette, LACyclic control rod movement was restricted due to improper installation of the lateral cyclic control rod by company maintenance personnel.NTSB ANC93LA068Accident · No injuriesLimited investigationFinal reportCessna 402B · Kivalina, AKThe pilot's failure to check the condition of the runway before takeoff. The soft runway condition was a factor in the accident.NTSB LAX93LA225Accident · 1 fatalLimited investigationFinal reportCessna 172N · Page, AZthe pilot's selection of an inadequate cruise altitude. A factor in the accident was the high winds and turbulence in the vicinity of the cliffs.NTSB LAX93LA222Accident · No injuriesLimited investigationFinal reportCessna 182P · Reno, NVIncorrect installation of a bearing in the airplane's alternator during overhaul by maintenance personnel. A factor in the accident was the rough, uneven terrain.NTSB FTW93LA164Accident · No injuriesLimited investigationFinal reportPiper PA-25-151 · Calera, OKAircraft performance exceeded and takeoff not aborted. Factors were the soft wet turf runwayNTSB SEA93LA120Accident · No injuriesLimited investigationFinal reportCessna 185A · Lowell, IDFatigue of the rocker arm and unsuitable terrain which was encountered during the precautionary landing.NTSB SEA93LA119Accident · No injuriesLimited investigationFinal reportApplebay Zuni · Deer Park, WAImproperly planned approach by the PIC.NTSB SEA93LA118Accident · No injuriesLimited investigationFinal reportCessna 150M · Bellingham, WAThe inadequate compensation for wind conditions by the student pilot. Factors relating to the accident were the gusty wind conditions and the student's lack of total experience.NTSB MIA93FA129Accident · Serious injuriesField investigationFinal reportBeech F33A · Oxford, MSLoss of engine power for undetermined reasons. The lack of suitable terrain for a forced landing was a factor.NTSB LAX93LA221Accident · No injuriesLimited investigationFinal reportCessna 150E · Hollister, CAfuel exhaustion due to the pilot's inadequate preflight inspection of the aircraft and his failure to refuel the aircraft prior to departure.NTSB DEN93LA061Accident · No injuriesLimited investigationFinal reportCessna 172N · Buena Vista, COA downdraft and the pilot's failure to maintain directional control of the airplane. Factors were: a crosswind and the inadvertent selection of additional flaps.NTSB ATL93LA096Accident · No injuriesLimited investigationFinal reportCessna 182Q · Hartselle, ALThe pilot's misjudgement of distance and speed during the approach and landing.NTSB ANC93LA086Accident · No injuriesLimited investigationFinal reportCessna 185 · Barrow, AKThe fatigue fracture of the main landing gear spring.NTSB SEA93LA138Accident · No injuriesLimited investigationFinal reportBeech 60 · Bullfrog, UTInadvertent landing gear retraction.NTSB MIA93LA128Accident · No injuriesLimited investigationFinal reportJohn Shufflebarger Zenair Zodiak · Lakeland, FLThe failure of the pilot-in-command to maintain airspeed after separation of the canopy, resulting in the aircraft entering a stall/mush condition and descending uncontrolled to the ground. Contributing to the accident was the failure of the pilot-in-command…NTSB FTW93LA162Accident · No injuriesLimited investigationFinal reportCessna A185F · Timbalier Isle, LAPilot's inadequate preflight planning and preparation in the selection of his takeoff route. A factor was the sand barNTSB CHI93FA180Accident · 1 fatalField investigationFinal reportBeech C-18S · North Branch, MNexcessive use of brakes by the pilot-in-command.NTSB ATL93LA095Accident · No injuriesLimited investigationFinal reportCessna 172 · Athens, TNFailure of the aircraft engine to produce power for unknown reasons.NTSB SEA93LA117Accident · 1 fatalLimited investigationFinal reportStinson 108-1 · Brigham City, UTThe premature liftoff by the PIC and his failure to attain proper rate of climb. Factors relating to the accident were the gusty crosswind weather conditions, the failure of the PIC to use all available runway, and transmission wires.NTSB SEA93LA116Accident · Serious injuriesLimited investigationFinal reportRambow Monnett Moni · Ritzville, WAThe improper landing flare.NTSB MIA93LA126Accident · No injuriesLimited investigationFinal reportCessna 170B · Titusville, FLThe pilot-in-command's failure to compensate for wind conditions, resulting in loss of directional control during landing roll.NTSB MIA93FA127Accident · 4 fatalField investigationFinal reportCessna 172N · Deerfield Beach, FLFailure of the pilot-in-command to maintain airspeed (vso). The low altitude at the time of the aerodynamic stall was a factor.NTSB LAX93LA220Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Vacaville, CAthe pilot's failure to maintain directional control after encountering strong and gusty cross winds during the landing flare.NTSB FTW93LA161Accident · No injuriesLimited investigationFinal reportLewis RV4 · Tyler, TXPilot's loss of directional control.NTSB CHI93LA179Accident · Minor injuriesLimited investigationFinal reportBell 47 · Berlin, WIThe pilot-in-command's failure to see the obstruction.NTSB CHI93LA178Accident · No injuriesLimited investigationFinal reportCessna 188A · Harrisonville, MOPilot in command's failure to attain a proper climb.NTSB CHI93LA177Accident · 1 fatalLimited investigationFinal reportCessna 120 · Crawford, NEThe pilot's failure to maintain adequate airspeed.NTSB CHI93DCD02Accident · 1 fatalFinal reportPiper PA-25 · Essex, IAFatigue failure of the forward spar fuselage attachment assembly for the right wing. A factor related to the accident was: the lack of a directed inspection procedure that could have been provided with the issuance of an airworthiness directive.NTSB BFO93LA096Accident · No injuriesLimited investigationFinal reportRyan Navion · Cumberland, RILoss of engine power due to undetermined reasons. A factor related to the accident was rough and uneven terrain.NTSB BFO93LA095Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS-233A · Johnson City, NYImproper planning/decision by the flight crew. Factors related to the accident were: the downdraft on final approach, the terrain conditions (cliff & obstructions) near the approach end of the runway, and the lack of relative experience for each of the pilots.NTSB SEA93LA113Accident · Minor injuriesLimited investigationFinal reportMurphy Barracuda · Yoncalla, ORThe engine oil filter vibrating loose resulting in oil starvation, and the pilot in command's misjudgment of winds. A factor contributing to the accident was unfavorable winds.NTSB MIA93LA125Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Sarasota, FLThe pilot-in-command's improper application of the flight controls during an autorotative landing, resulting in an in-flight collision with wires and terrain. Contributing to the accident was the improper inspection of the engine fuel system (carburetor) by…NTSB MIA93LA124Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Leesburg, FLThe pilot-in-command's failure to initiate a climb.NTSB MIA93LA123Accident · No injuriesLimited investigationFinal reportCessna 172RG · Fort Lauderdale, FLThe failure of the left main gear pivot assembly, resulting in the collapse of the left main landing gear during the landing rollout.NTSB FTW93LA160Accident · No injuriesLimited investigationFinal reportCessna 152 · Belmont, LAThe loss of engine power due to a sheared accessory drive pin. A factor was the unsuitable terrainNTSB ATL93LA094Accident · No injuriesLimited investigationFinal reportBellanca GC-BC · Panama City, FLThe failure of the pilot to maintain control of the aircraft and his poor inflight decision to attempt a downwind landing at the 975 foot airfield. A factor was the tail wind condition which existed at the airfield at the timeNTSB SEA93LA115Accident · No injuriesLimited investigationFinal reportLarkin Pitts Special · Nampa, IDThe pilot failed to maintain directional control during landing ground roll.NTSB SEA93LA114Accident · No injuriesLimited investigationFinal reportMaule M-4-210C · Moscow, IDThe inadequate visual lookout by the pilot and his failure to maintain clearance from electrical transmission wires. Factors relating to the accident were the sunglare and the presence of the wires.NTSB SEA93LA112Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Hardin, MTThe pilot in command's failure to maintain directional control.NTSB CHI93LA175Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Mexico, MOa loss of engine power for undetermined reasons. A factor in the accident was the soft field landing site.NTSB ANC93LA066Accident · No injuriesLimited investigationFinal reportCessna 180H · Ketchikan, AKThe pilot in commands improper compensation for the wind condition. A factor in the accident was the unfavorable wind.