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.

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.Jan 28, 1998 · N503MZ · Substantial damageNTSB 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.Jan 28, 1998 · N340CK · Substantial damageNTSB 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.Jan 27, 1998 · N7921S · Substantial damageNTSB 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.Jan 27, 1998 · N135KA · Substantial damageNTSB FTW98LA107Accident · Serious injuriesLimited investigationFinal reportSutton Tierra II · Woodson, ARThe pilot's inability to maintain control of the airplane for undetermined reasons.Jan 27, 1998 · N131WH · Substantial damageNTSB 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.Jan 27, 1998 · N30192 · Substantial damageNTSB 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…Jan 26, 1998 · N8189Q · Substantial damageNTSB 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.Jan 26, 1998 · N5099W · DestroyedNTSB 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.Jan 25, 1998 · N3463 · Substantial damageNTSB LAX98LA077Accident · No injuriesLimited investigationFinal reportPitts S1 · Prescott, AZThe pilot's failure to maintain directional control of the aircraft.Jan 25, 1998 · N28K · Substantial damageNTSB FTW98LA109Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Alexandria, LAThe fire in the normal braking system due to an undetermined reason.Jan 25, 1998 · N2881D · Substantial damageNTSB 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.Jan 25, 1998 · N110RR · Substantial damageNTSB 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.Jan 24, 1998 · N2994P · Substantial damageNTSB 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.Jan 24, 1998 · N521ZZ · DestroyedNTSB IAD98WA029Accident · 1 fatalForeign investigationAir Tractor AT-501W · Santa Maria, PortugalJan 24, 1998 · N1006T · DestroyedNTSB FTW98LA106Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Taos, NMthe pilot's improper flare and improper recovery from a bounced landing.Jan 24, 1998 · N376AA · Substantial damageNTSB 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.Jan 24, 1998 · N377V · Substantial damageNTSB 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.Jan 24, 1998 · N2609K · Substantial damageNTSB SEA98LA028Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Sutherlin, ORLoss of engine power for an undetermined reason.Jan 23, 1998 · N8422P · Substantial damageNTSB LAX98LA081Accident · No injuriesLimited investigationFinal reportCessna 340A · Groveland, CAFailure of the brake line as a result of inadequate maintenance.Jan 23, 1998 · N41NR · Substantial damageNTSB 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.Jan 23, 1998 · N972SA · No damageNTSB 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.Jan 22, 1998 · N15827 · Substantial damageNTSB 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…Jan 22, 1998 · N1093N · Substantial damageNTSB 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.Jan 22, 1998 · N759QZ · Substantial damageNTSB 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.Jan 22, 1998 · N911KA · Substantial damageNTSB ANC98LA016Accident · No injuriesLimited investigationFinal reportCessna 150 · Pt. Baker, AKThe pilot's failure to maintain directional control.Jan 22, 1998 · N5822E · Substantial damageNTSB 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.Jan 21, 1998 · N854CA · Substantial damageNTSB 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.Jan 21, 1998 · N269M · DestroyedNTSB 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.Jan 20, 1998 · N266RP · Substantial damageNTSB DCA98WA022Incident · No injuriesForeign investigationSaab-Scania 2000 · Clerrmont-Ferra, FranceJan 20, 1998 · GTSE · No damageNTSB 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.Jan 20, 1998 · N738FX · Substantial damageNTSB 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.Jan 20, 1998 · N12038 · DestroyedNTSB ATL98LA035Accident · No injuriesLimited investigationFinal reportPiper J5-A · Vero Beach, FLloss of engine power for undetermined reasons.Jan 20, 1998 · N38645 · Substantial damageNTSB 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.Jan 19, 1998 · N27CP · Substantial damageNTSB CHI98LA081Accident · Serious injuriesLimited investigationFinal reportPiper PA-28RT-201T · Naperville, ILimproper preflight planning and preparation by the pilot which resulted in fuel exhaustion.Jan 19, 1998 · N8277W · DestroyedNTSB ATL98LA034Accident · No injuriesLimited investigationFinal reportAmerican General AA-1A · Orlando, FLThe pilot's failure to maintain flying speed.Jan 18, 1998 · N6364L · Substantial damageNTSB 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.Jan 18, 1998 · N7443G · Substantial damageNTSB NYC98LA061Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Lake Placid, NYwas the pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin.Jan 17, 1998 · N150JH · DestroyedNTSB 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.Jan 17, 1998 · N7911F · Substantial damageNTSB LAX98LA076Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas 600N · Mesa, AZThe second pilot misjudging his flare and the delayed remedial actions by the pilot-in-command.Jan 17, 1998 · N176SP · Substantial damageNTSB 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.Jan 17, 1998 · N114GP · DestroyedNTSB 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.Jan 17, 1998 · N656AC · DestroyedNTSB 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.Jan 17, 1998 · N132BC · Substantial damageNTSB 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.Jan 16, 1998 · N4498C · Substantial damageNTSB 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.Jan 16, 1998 · N99302 · DestroyedNTSB FTW98FA100Accident · 1 fatalField investigationFinal reportAir Tractor 502B · Eudora, ARThe pilot's failure to maintain adequate airspeed while attempting an aerobatic manueverJan 16, 1998 · N6093U · DestroyedNTSB 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.Jan 15, 1998 · N7901S · Substantial damageNTSB 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.Jan 15, 1998 · N54643 · DestroyedNTSB IAD98LA022Accident · No injuriesLimited investigationFinal reportCessna 182M · Mount Pleasant, PAThe pilot's failure to initiate a go-around, and his failure to maintain adequate airspeed.Jan 14, 1998 · N71763 · DestroyedNTSB 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.Jan 14, 1998 · N82BP · Substantial damage