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 FTW98LA110Accident · No injuriesLimited investigationFinal reportAviat A-1 · Buena Vista, COThe pilot's failure to maintain directional control of the airplane. Factors were the crosswind changing to a tailwind, and the pilot's lack of experience in the type of aircraft.NTSB FTW98LA108Accident · No injuriesLimited investigationFinal reportCessna 340 · Wagoner, OKthe entrance of deer onto the runway, which resulted in an unavoidable impact. Darkness was a related factor.NTSB LAX98LA078Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Van Nuys, CAThe student pilot's inadequate compensation for the existing crosswind condition and failure to maintain directional control. A related factor was the crosswind.NTSB IAD98LA024Accident · Minor injuriesLimited investigationFinal reportKaman K-1200 · Bloomfield, CTThe pilot's failure to maintain control during autorotation, which resulted in an unleveled attitude touchdown, roll over, and collision with the ground.NTSB FTW98LA107Accident · Serious injuriesLimited investigationFinal reportSutton Tierra II · Woodson, ARThe pilot's inability to maintain control of the airplane for undetermined reasons.NTSB ATL98LA041Accident · No injuriesLimited investigationFinal reportCessna 177 · New Port Richey, FLpartial loss of engine power for undetermined reasons, which led to a forced landing and collision with trees.NTSB CHI98LA088Accident · No injuriesLimited investigationFinal reportCessna 310Q · Kenosha, WIthe pilot's failure to lower the landing gear and to properly align the airplane with the runway. Factors associated with the accident were: the inoperative gear warning, degraded aircraft performance, the pilot's diverted attention, the pilot's decision to…NTSB CHI98FA086Accident · 2 fatalField investigationFinal reportPiper PA-28-160 · Faribault, MNwas the pilot's patial incapacitation due to carbon monoxide poisoning. A factor associated with this accident was the mechanic's inadequate inspection of the airplane's muffler and inadequate preflight planning and preparation by the pilot.NTSB LAX98LA084Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Prescott Valley, AZThe failure of the ground crew to correctly attach the tow bridle, which resulted in the pilot's loss of directional control.NTSB LAX98LA077Accident · No injuriesLimited investigationFinal reportPitts S1 · Prescott, AZThe pilot's failure to maintain directional control of the aircraft.NTSB FTW98LA109Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Alexandria, LAThe fire in the normal braking system due to an undetermined reason.NTSB CHI98LA087Accident · No injuriesLimited investigationFinal reportPiper J3C · Mankato, MNthe pilot's inadequate compensation for the wind conditions and not maintaining proper alignment. Factors contributing to the accident were the snow covered terrain and the lack of depth perception it produced.NTSB MIA98LA078Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Sarasota, FLinadequate clearance and fretting wear of the fitting/beam attachment to the angle/top beam, due to inadequate design, which resulted in fatigue and subsequent failure of the fitting/beam attachment ear.NTSB LAX98LA079Accident · 1 fatalLimited investigationFinal reportHughes 369D · Pacific Ocean (Pacific Ocean)The pilot's failure to adequately compensate for the wind condition and failure to maintain a proper rate of descent which resulted in the inadvertent loss of tail rotor effectiveness during a downwind turn.NTSB IAD98WA029Accident · 1 fatalForeign investigationAir Tractor AT-501W · Santa Maria, PortugalNTSB FTW98LA106Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Taos, NMthe pilot's improper flare and improper recovery from a bounced landing.NTSB FTW98LA105Accident · No injuriesLimited investigationFinal reportCessna 140A · Justin, TXthe pilot's improper planning/decision and failure to ensure that the airplane would be able to remain clear of the fence during takeoff. Factors relating to the accident were: the wet/soft/short runway (and terrain) conditions.NTSB ATL98LA040Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Laurens, SCThe pilot's inadequate weather evaluation that resulted in initiating flight in marginal visual conditions, and resulted in fuel exhaustion.NTSB SEA98LA028Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Sutherlin, ORLoss of engine power for an undetermined reason.NTSB LAX98LA081Accident · No injuriesLimited investigationFinal reportCessna 340A · Groveland, CAFailure of the brake line as a result of inadequate maintenance.NTSB ATL98IA039Incident · No injuriesIncident investigationFinal reportRobinson R-44 · Miami, FLAn inadequate service bulletin which did not require measurement of the cyclic trim assembly shaft and did not identify all helicopters in which shaft wear could lead to restricted movement of the lateral cyclic trim.NTSB NYC98FA062Accident · Minor injuriesField investigationFinal reportAerospatiale ATR-42-320 · Windsor Locks, CTThe improper overhaul of lug holes on the fuel/oil heat exchanger. A factor was the lack of direction contained in the manufacturer's overhaul manual for working with the lug holes.NTSB FTW98TA104Accident · Minor injuriesFinal reportHughes 269C · Brackettville, TXfailure of splines on the drive shaft coupling after separation of the forward bubber boot and loss of lubrication (grease), which resulted in a disconnect of the rotor drive system and an autorotation/forced landing. Lack of suitable terrain in the forced…NTSB FTW98LA113Accident · No injuriesLimited investigationFinal reportCessna 182Q · Keeline, WYfailure of the pilot to maintain directional control of the airplane during the landing roll. Factors relating to the accident included: a snow covered/icy/muddy area on the runway, and the proximity of a snowbank to the runway.NTSB ATL98LA038Accident · No injuriesLimited investigationFinal reportBeech 65-A90 · Selmer, TNThe loss of control on the ground, due to hydroplaning, and a collision with trees. A factor was the rain.NTSB ANC98LA016Accident · No injuriesLimited investigationFinal reportCessna 150 · Pt. Baker, AKThe pilot's failure to maintain directional control.NTSB IAD98LA023Accident · No injuriesLimited investigationFinal reportBeech 1900D · Saranac Lake, NYThe inadequate snow removal from the runway by airport personnel which left a snow bank extending onto the runway.NTSB ATL98FA036Accident · 3 fatalField investigationFinal reportTwin Commander Acft. 695A · Delray Beach, FLThe pilot flew into known convective meterological conditions and lost control of the airplane. Factors were low clouds, and moderate to heavy rain.NTSB FTW98LA408Accident · No injuriesLimited investigationFinal reportPalermo Challenger II · Erwinville, LAThe pilot's failure to compensate for the prevailing crosswind. Factors were the crosswind and the loss of engine power due to the separation of the fuel pick-up line.NTSB DCA98WA022Incident · No injuriesForeign investigationSaab-Scania 2000 · Clerrmont-Ferra, FranceNTSB CHI98LA084Accident · No injuriesLimited investigationFinal reportCessna 208B · Grand Island, NEice build-up on the airplane's wings and empennage which led to an inadvertent stall and hard landing. Factors contributing to this accident were the pilot's inadvertent flight into icing conditions, and the icing conditions.NTSB CHI98LA083Accident · Minor injuriesLimited investigationFinal reportNerstrom-Tailwind W-8 · Lodi, WIthe pilot's failure to maintain a proper altitude due to the whiteout conditions. Factors associated with the accident were the low pass performed by the pilot and the visual illusion created by the whiteout conditions.NTSB ATL98LA035Accident · No injuriesLimited investigationFinal reportPiper J5-A · Vero Beach, FLloss of engine power for undetermined reasons.NTSB FTW98LA102Accident · Serious injuriesLimited investigationFinal reportMartin Varieze · Artesia, NMThe pilot's inadequate compensation for the crosswind. Factors were the prevailing crosswind and the pilot's lack of total experience in type of aircraft.NTSB CHI98LA081Accident · Serious injuriesLimited investigationFinal reportPiper PA-28RT-201T · Naperville, ILimproper preflight planning and preparation by the pilot which resulted in fuel exhaustion.NTSB ATL98LA034Accident · No injuriesLimited investigationFinal reportAmerican General AA-1A · Orlando, FLThe pilot's failure to maintain flying speed.NTSB ATL98LA033Accident · 1 fatalLimited investigationFinal reportCessna 150L · Guntersville, ALThe pilot's intentional shut down of the engine in flight that resulted in the total loss of engine power. A factor was the failure of both magnetos.NTSB NYC98LA061Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Lake Placid, NYwas the pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin.NTSB LAX98LA080Accident · No injuriesLimited investigationFinal reportCessna 150F · San Carlos, CAThe pilot's excessive airspeed, which resulted in a bounced landing, and, his failure to ensure that his seat locking pin was engaged, which caused his seat to move backwards during the touchdown and resulted in his loss of directional control.NTSB LAX98LA076Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas 600N · Mesa, AZThe second pilot misjudging his flare and the delayed remedial actions by the pilot-in-command.NTSB LAX98FA075Accident · 1 fatalField investigationFinal reportCessna 402C · Walker, CAThe pilot's encounter with a downdraft while approaching high terrain at an altitude insufficient to ensure adequate terrain or obstacle clearance.NTSB ATL98LA032Accident · 2 fatalLimited investigationFinal reportVia Aero Comp AC6 · Rockledge, FLThe loss of engine power for undetermined reasons. A factor was the trees in the emergency landing area.NTSB ATL98LA031Accident · No injuriesLimited investigationFinal reportChristopher Coats Challenger II · Evergreen, ALThe undetermined failure of the propeller bolts that resulted in the inflight separation of the propeller assembly. A factor was the overpass bridge.NTSB LAX98LA074Accident · No injuriesLimited investigationFinal reportCessna 195 · Long Beach, CAThe pilot's failure to maintain directional control during the landing, which led to a ground loop and a resultant overload failure of the right main landing gear attach points.NTSB FTW98FA101Accident · 1 fatalField investigationFinal reportPiper PA-18-135 · Wooster, ARthe pilot's failure to maintain clearance with trees during an aborted landing. A contributing factor was the pilot's delayed decision to abort the long landing.NTSB FTW98FA100Accident · 1 fatalField investigationFinal reportAir Tractor 502B · Eudora, ARThe pilot's failure to maintain adequate airspeed while attempting an aerobatic manueverNTSB FTW98TA099Accident · No injuriesFinal reportBell 47G-3B-1 · Magdalena, NMThe pilot's failure to maintain adequate main rotor rpm. A factor was a lack of recent experience in the type of operation being performed.NTSB CHI98FA082Accident · 1 fatalField investigationFinal reportBeech 95-55 · Pinckneyville, ILThe pilot descent below minimum descent altitude and his intentional operation with known deficiencies in equipment. Factors were the dark night, fog, rain, and the trees.NTSB IAD98LA022Accident · No injuriesLimited investigationFinal reportCessna 182M · Mount Pleasant, PAThe pilot's failure to initiate a go-around, and his failure to maintain adequate airspeed.NTSB FTW98LA098Accident · 1 fatalLimited investigationFinal reportPoling Keleher Lark KR1B · Georgetown, TXThe pilot's failure to maintain aircraft control. A contributing factor was the pilot's physical impairment due to drugs.