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 ANC91LA074Accident · No injuriesLimited investigationFinal reportCessna A185E · King Salmon, AKFuel exhaustion, the pilot's inadequate preflight and the inadequate fuel consumption calculations. Contributing to the accident was the soft terrain, and tundra.Jun 15, 1991 · N70148 · Substantial damageNTSB MIA91LA163Accident · No injuriesLimited investigationFinal reportAir Tractor 301 · Greenville, MSLoss of engine power due to a cracked cylinder and the pilot's inadvertent stall.Jun 14, 1991 · N2361C · Substantial damageNTSB LAX91TL#06Accident · No injuriesClass 3Final reportBell 212 · Coulterville, CAJun 14, 1991 · N500EH · Substantial damageNTSB FTW91LA097Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · New Orleans, LAThe pilot's improper recovery from a bounced landing. A factor was: the pilot's lack of total experience in model.Jun 14, 1991 · N44447 · Substantial damageNTSB FTW91LA096Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Farmerville, LAA fuel starvation induced power loss due to the pilot's failure to select the proper fuel tank.Jun 14, 1991 · N6278A · Substantial damageNTSB DEN91LA086Accident · No injuriesLimited investigationFinal reportNaval Aircraft Factory N3N-3 · Deming, NMThe pilot's failure to maintain directional control. Factors were: a crosswind condition and a soft shoulder alongside the runway.Jun 14, 1991 · N44970 · Substantial damageNTSB CHI91LA191Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Eagle Bend, MNThe pilot in command's failure to attain proper alignment with the runway. Factors contributing to this accident were an unreliable airspeed indicator and the pilot's decision to operate with this known deficiency.Jun 14, 1991 · N3130Z · Substantial damageNTSB CHI91DER07Accident · No injuriesFinal reportPiper PA-36-375 · Breckentidge, MNThe pilot's failure to take adequate remedial action during the attempted climb out. A related factor is the premature lift off.Jun 14, 1991 · N3866E · Substantial damageNTSB SEA91LA130Accident · Minor injuriesLimited investigationFinal reportHughes 269A-1 · Canby, ORA hard landing after an undetermined loss of power. Factors include an excessive emergency descent rate.Jun 13, 1991 · N8944F · Substantial damageNTSB LAX91TL#07Accident · No injuriesClass 3Final reportAerospatiale AS350 · Los Angeles, CAJun 13, 1991 · N214LA · DestroyedNTSB DEN91FA083Accident · 1 fatalField investigationFinal reportSchempp-Hirth Ventus C · Durango, COThe absence of thermal lift, the pilot's apprehension, and his lack of familiarity with the geographic area.Jun 13, 1991 · N418CH · DestroyedNTSB CHI91LA190Accident · No injuriesLimited investigationFinal reportCessna 195 · Detroit, MIFailure to maintain directional control, and inadequate aircraft preflight. A factor related to the accident is the instructor pilot's lack of experience in the type aircraft.Jun 13, 1991 · N4351V · Substantial damageNTSB CHI91LA189Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Wausa, NEThe pilot's delayed decision to turn around after encountering IFR flight conditions. Factors were restricted forward visibility and power lines.Jun 13, 1991 · N1721C · Substantial damageNTSB CHI91DCQ06Accident · No injuriesFinal reportPiper PA-36-300 · Oakley, KSA loss of engine power for an undetermined reason(s).Jun 13, 1991 · N59661 · Substantial damageNTSB BFO91LA054Accident · No injuriesLimited investigationFinal reportGrumman AA-1C · Union Hall, VAThe loss of engine power brought on by a failure of the number three clyinder exhaust valve. Contributing to the accident was a hidden object on the emergency landing field.Jun 13, 1991 · N9755U · Substantial damageNTSB ANC91LA073Accident · No injuriesLimited investigationFinal reportCessna 180 · Pilot Point, AKFuel exhaustion, due to the Pilot's inadequate preflight. Contributing to the accident was the soft and rough terrain.Jun 13, 1991 · N420SB · Substantial damageNTSB ANC91LA072Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Kenai, AKThe pilot-in-command's improper preflight and the contaminated fuel system. A factor was the rough, uneven terrain.Jun 13, 1991 · N3459M · Substantial damageNTSB MIA91WA162Accident · No injuriesForeign investigationAero Commander 680-E · Nassau, BahamasJun 12, 1991 · N6266B · Substantial damageNTSB MIA91LA161Accident · No injuriesLimited investigationFinal reportCessna 172K · Jacksonville, FLTotal loss of engine power due to fatigue failure of the oil cooler resulting in oil exhaustion. Contributing to the accident was lack of suitable terrain.Jun 12, 1991 · N79542 · Substantial damageNTSB LAX91LA259Accident · Minor injuriesLimited investigationFinal reportPiper J3L · Shasta Lake, CAThe pilot-in-command's failure to maintain airspeed on initial takeoff climb resulting in an in flight loss of control, stall, and inflight collision with terrain/water.Jun 12, 1991 · N23195 · Substantial damageNTSB DEN91LA082Accident · No injuriesLimited investigationFinal reportBoeing DHC-6-300 · Denver, COThe pilot's failure to perform an adequate preflight, I.e., not following the check list and the normal brake system was inoperative as a result of no hydraulic system pressure (hydraulic system circuit breaker not 'in').Jun 12, 1991 · N242CA · Substantial damageNTSB CHI91LA188Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-34 · Highland, ILThe pilot misjudged his touchdown point.Jun 12, 1991 · N7634 · Substantial damageNTSB LAX91LA277Accident · No injuriesLimited investigationFinal reportFairchild SA227-AC · Visalia, CAThe instructor/pilot-in-command's failure to adequately supervise the flight and the second pilot's improper use of the checklist and failure to maintain crew coordination to ensure that the landing gear was extended. Contributing to the accident was the…Jun 11, 1991 · N348AE · Substantial damageNTSB LAX91LA258Accident · No injuriesLimited investigationFinal reportBeech F33A · Mobile, AZThe failure of the pilot of the other aircraft to exit the runway onto the taxiway at a speed sufficient to stop prior to colliding with the stopped aircraft.Jun 11, 1991 · N6486N · 2 aircraft · Substantial damageNTSB CHI91LA010Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Manning, IAAirspeed was not attained and aborted takeoff was delayed by the pilot. Factors related to the accident were: over confidence in aircraft's ability to takeoff on the short, grass runway and a dirt embankment on the departure end of the strip.Jun 11, 1991 · N44300 · Substantial damageNTSB CHI91DER05Accident · No injuriesFinal reportBell 47G3B1 · Lasalle, MNThe pilot's failure to maintain adequate clearance from the terrain. A related factor is the pilot's misjudged altitude above the crop.Jun 11, 1991 · N73284 · Substantial damageNTSB ATL91LA109Accident · No injuriesLimited investigationFinal reportCessna 172M · Knighdale, NCFailure of the pilot to attain the proper touch down point on the runway and/or perform a go-around.Jun 11, 1991 · N12498 · Substantial damageNTSB SEA91LA145Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Corvallis, ORThe pilot displayed poor in-flight planning. A factor to the accident was: the pilot did not maintain a proper altitude over mountainous terrain.Jun 10, 1991 · N3474Z · DestroyedNTSB LAX91LA243Accident · 2 fatalLimited investigationFinal reportCessna 182E · Eureka, CAThe non-instrument rated pilot's inadvertent flight into IMC conditions. The pilot's lack of total experience, his disregard to the preflight meteorological briefing he received, low ceilings, fog, and the mountainous terrain over which the flight was…Jun 10, 1991 · N3046Y · DestroyedNTSB CHI91LA187Accident · No injuriesLimited investigationFinal reportGrumman American AA1C · Lansing, KSThe pilot became lost/disoriented and attempted a precautionary landing. Factors related to the accident were a low level of fuel and soft terrain (wheat field crop).Jun 10, 1991 · N9688U · Substantial damageNTSB ANC91LA068Accident · No injuriesLimited investigationFinal reportCessna 140 · Kenai, AKThe pilot's failure to maintain directional control. A factor was the gusty wind conditions.Jun 10, 1991 · N81074 · Substantial damageNTSB NYC91FA144Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · East Haddam, CTThe non-mechanical loss of engine power due to the failure of the pilot to use the auxiliary fuel boost pump during takeoff.Jun 9, 1991 · N2876Z · Substantial damageNTSB LAX91LA257Accident · 1 fatalLimited investigationFinal reportSchweizer 269B · Cottonwood, CAThe pilot's inadequate visual lookout. The transmission wire was a factor in the accident.Jun 9, 1991 · N103AB · DestroyedNTSB LAX91LA256Accident · No injuriesLimited investigationFinal reportWeaver WACO-ASO · Montague, CAFailure of the pilot to maintain directional control of the airplane and improper use of the brakes.Jun 9, 1991 · N4W · Substantial damageNTSB FTW91LA094Accident · No injuriesLimited investigationFinal reportPitts S1C · Houston, TXThe failure of the propeller due to improper installation.Jun 9, 1991 · N48JP · Substantial damageNTSB CHI91LA184Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Grass Lake, MIA ruptured oil cooler line. A factor associated with the accident was the lack of suitable terrain for the precautionary landing.Jun 9, 1991 · N7470R · Substantial damageNTSB CHI91LA183Accident · 1 fatalLimited investigationFinal reportBalloon Works FIREFLY-7B · Greenwood, MOThe inadequate briefing to the ground crew by the pilot, because the ground crewman did not understand the intent and objectives of the maneuver.Jun 9, 1991 · N3605G · Minor damageNTSB ANC91LA071Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot's failure to maintain directional control of the airplane during the landing roll. Contributing to the accident was the crosswind.Jun 9, 1991 · N8466Y · Substantial damageNTSB ANC91LA070Accident · No injuriesLimited investigationFinal reportCessna 180 · Near Iliamna, AKThe pilot's decision to land on an unimproved area. The soft terrain was a related factor.Jun 9, 1991 · N5296D · Substantial damageNTSB SEA91LA129Accident · No injuriesLimited investigationFinal reportBoeing E75 · Aurora, ORAn improperly adjusted carburetor and improper maintenance. Factors include an earthen berm which the aircraft struck during the landing roll.Jun 8, 1991 · N1067N · Substantial damageNTSB NYC91LA152Accident · Serious injuriesLimited investigationFinal reportGlasflugel Libelle 201B · Saratoga, NYThe failure of the pilot to adequately flare when making an uphill landing. Factors related to the accident were the pilot continued attempts at finding lift which reduced his landing options when he decided to land.Jun 8, 1991 · N8041D · Substantial damageNTSB LAX91LA255Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Thermal, CAThe partial failure of the engine/powerplant from a worn intake valve and the failure of company/operator management to perform an overhaul on the engine within the time frame recommended by the engine manufacturer.Jun 8, 1991 · N6230D · Substantial damageNTSB LAX91LA254Accident · Serious injuriesLimited investigationFinal reportCullen/Roth Falcon XP · Sebastopal, CAThe structural failure of the airplane's canard wing. Contributing factors which related to the accident were the pilot's performance of an adjustment to the rigging of his airplane which deteriorated its flight characteristics.Jun 8, 1991 · N9939M · DestroyedNTSB LAX91LA253Accident · Minor injuriesLimited investigationFinal reportNorth American T-28B · Hollister, CAThe pilot's intentional bailing out of his airplane. Contributing factors are related to the possible onset of a rough running engine.Jun 8, 1991 · N993CA · DestroyedNTSB LAX91FA252Accident · 3 fatalField investigationFinal reportCessna 182 · Bermuda Dunes, CAThe pilot-in-command's failure to maintain airspeed while maneuvering to return to the departure airport, resulting in an in flight loss of control, stall, and in flight collision with terrain. Factors related to the accident were: partial loss of engine…Jun 8, 1991 · N7299E · DestroyedNTSB FTW91LA095Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Newport, ARThe pilot's improper planning which resulted in his flying into his own chemicals.Jun 8, 1991 · N36335 · Substantial damageNTSB FTW91DRG03Accident · Serious injuriesFinal reportGrumman G-164A · Weslaco, TXFailure of the pilot to maintain clearance.Jun 8, 1991 · N7445 · DestroyedNTSB FTW91DRA03Accident · No injuriesFinal reportBronner Skybolt · Alvin, TXThe pilot's failure to maintain terrain clearance. A factor was the pilot's decision to perform a low pass.Jun 8, 1991 · N773HD · Substantial damageNTSB DEN91LA081Accident · No injuriesLimited investigationFinal reportCessna 182P · Santa Fe, NMThe pilot misjudged the flare during landing.Jun 8, 1991 · N8494M · Substantial damageNTSB CHI91LA185Accident · Serious injuriesLimited investigationFinal reportRyan Navion A · Kankakee, ILThe pilot's poor in flight planning/decision making and misjudged fuel supply. A related factor is the inadequate emergency procedure.Jun 8, 1991 · N4374K · Substantial damage