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 SEA91LA041Accident · Minor injuriesLimited investigationFinal reportAero Commander 200D · Tooele, UTEngine fuel system blockage due to ice formation in the fuel system during a period of weather temperature extremes. A factor was the lack of suitable terrain for a forced landing.Jan 13, 1991 · N235M · DestroyedNTSB LAX91LA073Accident · No injuriesLimited investigationFinal reportBeech D-35 · Bullhead City, AZLoss of directional control on the ground.Jan 13, 1991 · N2915B · Substantial damageNTSB CHI91LA072Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Springbrook, WIThe pilot's attempt to takeoff with a strong gusty tailwind.Jan 13, 1991 · N87867 · Substantial damageNTSB CHI91LA070Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Marshall, ILFlight into known adverse weather by the pilot(s) and subsequent icing of the Piper PA-32'S air induction system. Factors related to the accident were: the adverse weather conditions and a perceived sense of urgency to make the flight.Jan 13, 1991 · N3212W · DestroyedNTSB CHI91LA066Accident · No injuriesLimited investigationFinal reportCessna 140 · So. Sioux City, NEDirectional control not maintained by the pilot-in-command. Factors related to the accident were a snow covered runway and a lack of recent experience.Jan 13, 1991 · N1978V · Substantial damageNTSB SEA91LA043Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Wolf Point, MTThe inadequate preflight planning and preparation by the pilot in command, and his selection of unsuitable terrain for takeoff. A factor relating to the accident was the snowdrifts in the takeoff area.Jan 12, 1991 · N2787P · Substantial damageNTSB MIA91WA065Accident · No injuriesForeign investigationPiper PA-23-250 · Little Whale, BahamasJan 12, 1991 · N68RS · Substantial damageNTSB LAX91DUQ01Accident · No injuriesFinal reportVirgil D. Hawks Quickie · Camarillo, CAThe pilot's encounter with wake turbulence and his inflight loss of control by his failure to maintain a sufficient landing distance from a larger aircraft preceding his aircraft.Jan 12, 1991 · N13VD · Substantial damageNTSB CHI91LA069Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Ashland, NEThe pilot's failure to maintain clearance above the terrain. Factors related to the accident were the low pass and ostentatious display.Jan 12, 1991 · N2115A · Substantial damageNTSB CHI91LA068Accident · No injuriesLimited investigationFinal reportCessna 182A · Chadron, NEAn engine power loss for undetermined reasons.Jan 12, 1991 · N6082B · Substantial damageNTSB CHI91LA067Accident · No injuriesLimited investigationFinal reportBeech 200 · Vichy, MOA restricted visual outlook and go-around was not performed by the pilot. Factors related to the accident were a dark night, fog and glare, ice covered runway and whiteout conditions.Jan 12, 1991 · N200MR · Substantial damageNTSB MIA91LA064Accident · No injuriesLimited investigationFinal reportCessna 175 · Okeechobee, FLFailure of the right brake line at the caliper during the landing roll rendering the brakes ineffective. A factor was the pilot's misjudgement of wind direction.Jan 11, 1991 · N7293M · Substantial damageNTSB LAX91LA072Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Torrance, CAThe pilot's improper use of the rotorcraft's flight controls. Contributing factors were related to the pilot's lack of experience in the type of low altitude maneuver.Jan 11, 1991 · N40231 · Substantial damageNTSB FTW91FA029Accident · Serious injuriesField investigationFinal reportBeech F-90 · Nacogdoches, TXThe loss of thrust due to the propeller's feathering on liftoff as a result of improper adjustments made during an engine change. A factor was the lack of suitable terrain to which the pilot could execute a forced landing.Jan 11, 1991 · N311DS · DestroyedNTSB CHI91LA065Accident · No injuriesLimited investigationFinal reportCessna 152 II · St. Cloud, MNThe student pilot's failure to maintain directional control during acceleration for takeoff.Jan 11, 1991 · N4872B · Substantial damageNTSB ATL91FA020Accident · 2 fatalField investigationFinal reportMooney M20F · Pageland, SCFailure of the pilot to maintain control of the aircraft, due to spatial disorientation. Factors related to the accident were: the weather conditions and the malfunction of a gyro instrument (probably the attitude indicator).Jan 11, 1991 · N6858V · DestroyedNTSB LAX91LA071Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Ramona, CAThe pilot's failure to maintain directional control of the airplane during an attempted takeoff. A contributing factor was related to the student's improper use of rudder control.Jan 10, 1991 · N8309H · Substantial damageNTSB FTW91FA028Accident · 2 fatalField investigationFinal reportFolland Gnat T-1 · Bossier City, LAImproper planning/decision by the pilot and his delay in diverting to an alternate airport, which resulted in fuel exhaustion due to lack of fuel. The adverse weather conditions and radio malfunction were related factors.Jan 10, 1991 · N3XR · DestroyedNTSB CHI91LA064Accident · Minor injuriesLimited investigationFinal reportCessna 320E · Elkhart, INA fractured landing gear retraction assembly component and the pilot's improper emergency procedure.Jan 10, 1991 · N4695X · Substantial damageNTSB MIA91LA063Accident · Serious injuriesLimited investigationFinal reportCessna 182N · La Belle, FLThe pilot's failure to maintain altitude. A factor was the pilot's failure to obtain a weather forecast.Jan 9, 1991 · N69UU · DestroyedNTSB LAX91LA070Accident · No injuriesLimited investigationFinal reportRobinson R22 · Scottsdale, AZThe instructor pilot's delay in executing a recovery flare from the autorotative descent, and the helicopter's inadequate altitude during flare. A contributing factor was related to the instructor pilot being inattentive to his student's performance.Jan 9, 1991 · N8005E · Substantial damageNTSB CHI91IA062Incident · No injuriesIncident investigationFinal reportBoeing 737-322 · Kansas City, MOImproper use of the throttles, and failure to maintain directional control by the first officer. Factors related to the incident are: ice on the runway, lack of total experience in the type aircraft and operation by the first officer, and inadequate…Jan 8, 1991 · N396UA · No damageNTSB MIA91WA062Accident · 2 fatalForeign investigationBeech 58 · St. Maarten I., NTJan 7, 1991 · N100GT · DestroyedNTSB LAX91LA067Accident · No injuriesLimited investigationFinal reportPiper PA 34-200T · Red Bluff, CAThe failure of the pilot in command to detect a descent below the minimum descent altitude for the approach in use.Jan 7, 1991 · N66SL · Substantial damageNTSB ATL91FAMS1Accident · 2 fatalMissing aircraftFinal reportCessna 172D · Missing (Atlantic Ocean)The pilot's continuation of visual flight into instrument meteorological conditions which resulted in spatial disorientation and a loss of aircraft control. Factors related to the accident were: the pilot's failure to obtain a weather briefing before…Jan 7, 1991 · N2165Y · DestroyedNTSB NYC91FA058Accident · 1 fatalField investigationFinal reportMooney M20K · Gallipolis, OHThe pilot allowed the speed of the airplane to get too slow, resulting in an inadvertant stall at too low an altitude to allow recovery. A factor relating to the accident was the pilot's trepidation about a successful landing because of the weather.Jan 6, 1991 · N231MC · DestroyedNTSB LAX91LA069Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Hilo, HIThe failure of the pilot to maintain an adequate airspeed while maneuvering. A factor in the accident was the pilot's decision to attempt steep and abrupt maneuvers during the takeoff initial climb phase.Jan 6, 1991 · N996MP · DestroyedNTSB LAX91LA068Accident · No injuriesLimited investigationFinal reportCessna 172N · Ukiah, CAThe failure of the pilot to maintain an adequate clearance from ground obstructions. A factor in the accident was: failure of the pilot to maintain an altitude sufficient to clear all obstructions along his route of flight.Jan 6, 1991 · N737FJ · Substantial damageNTSB LAX91FA066Accident · 1 fatalField investigationFinal reportCessna T210M · Sacramento, CAThe failure of the pilot-in-command to maintain control of the airplane while flying in instrument meteorological conditions and spatial disorientation of the pilot-in-command. Contributing to the accident was diversion of the pilot's attention to…Jan 6, 1991 · N6148B · DestroyedNTSB FTW91FA027Accident · 6 fatalField investigationFinal reportCessna 421B · Muskogee, OKThe pilot's failure to maintain control of the aircraft, due to spatial disorientation. Factors related to the accident were: darkness, adverse weather conditions, and the pilot's physical impairment from the chronic sinus infection.Jan 6, 1991 · N421H · DestroyedNTSB CHI91LA060Accident · No injuriesLimited investigationFinal reportCessna 150D · Ft. Atkinson, WIThe pilot's failure to refuel. A factor was unsuitable terrain for landing.Jan 6, 1991 · N4286U · Substantial damageNTSB CHI91FA059Accident · 1 fatalField investigationFinal reportCessna 172P · Freeport, ILThe pilot-in-command's failure to maintain airspeed. Factors contributing were the pilot-in-command's misuse of flaps and his lack of total experience in this type of operation.Jan 6, 1991 · N65567 · DestroyedNTSB MIA91IA061Incident · No injuriesIncident investigationFinal reportCessna 210M · Lutz, FLFuel line chafing, and in-flight fire caused by shorting of the electrical system which resulted in a forced landing with the landing gear not extended.Jan 5, 1991 · N823AR · Minor damageNTSB DEN91LA031Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Deming, NMPilot failure to maintain airspeed during takeoff climb resulting in a stall and subsequent loss of control of the aircraft. A factor was: the failure of the CFI to adequately supervise the student pilot.Jan 5, 1991 · N6031W · Substantial damageNTSB ANC91FA019Accident · No injuriesField investigationFinal reportCessna 172G · Wasilla, AKPilot's not removing the frost from the airplane before attempting to takeoff. Contributing to the accident was the pilot's delayed abort, and the berm.Jan 5, 1991 · N4468L · Substantial damageNTSB NYC91LA057Accident · Serious injuriesLimited investigationFinal reportBeech U35B · Columbia, OHThe pilot mismanaged his fuel and ran one of the fuel tanks dry, resulting in an engine failure, due to fuel starvation.Jan 4, 1991 · N2049K · DestroyedNTSB CHI91LA063Accident · No injuriesLimited investigationFinal reportCessna 150L · Bemidji, MNThe pilot's improper preflight inspection of the airplane.Jan 4, 1991 · N6803G · Substantial damageNTSB CHI91IA058Incident · Minor injuriesIncident investigationFinal reportBoeing B727-223 · Des Moines, IAAn oil leak originating from the auxiliary power unit which created smoke in the passenger cabin after it passed through the air conditioning/heating system equipment and associated duct work.Jan 4, 1991 · N6821 · No damageNTSB SEA91FA039Accident · 1 fatalField investigationFinal reportCessna 140 · Port Orchard, WAThe pilot's failure to initiate an aborted takeoff at a time that left adequate runway remaining to bring the aircraft to a stop.Jan 3, 1991 · N77179 · Substantial damageNTSB LAX91FA065Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Glendale, CAThe pilot's inadvertent VFR flight into instrument meteorological conditions (IMC), and his improper inflight decision to turn to the left, which resulted in flight toward higher terrain. The terrain and weather conditions were related factors.Jan 3, 1991 · N39778 · DestroyedNTSB CHI91LA056Accident · No injuriesLimited investigationFinal reportCessna 340 · Chesterfield, MOFailure of the pilot to maintain directional control during the landing roll. Factors related to the accident are a foggy windshield, misjudgement of altitude, premature landing flare, and slush on the runway.Jan 3, 1991 · N14DB · Substantial damageNTSB NYC91FA055Accident · 1 fatalField investigationFinal reportCessna 172P · Rattlesnake Isl, OHThe cfi's delayed decision to execute a go-around from a long landing and subsequent failure to obtain/maintain flying speed.Jan 2, 1991 · N9837L · Substantial damageNTSB MIA91LA060Accident · No injuriesLimited investigationFinal reportHughes 269C · Deland, FLFailure of the commercial pilot applicant to pull collective pitch and delay by the check airman to pull collective and apply power to recover, resulting in a hard landing.Jan 2, 1991 · N9574F · Substantial damageNTSB CHI91LA055Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Jerseyville, ILLoss of engine power for undetermined reasons and the icy runway conditions.Jan 2, 1991 · N735YN · Substantial damageNTSB ATL91LA036Accident · No injuriesLimited investigationFinal reportCessna 195B · La Grange, GAThe failure of the tailwheel steering spring.Jan 2, 1991 · N2187C · Substantial damageNTSB SEA91FA262Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Dayville, ORThe pilot's poor in flight decision. Factors include mountainous/hilly terrain.Jan 1, 1991 · N8982D · DestroyedNTSB NYC91LA056Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Princeton, NJPilot factor in that the pilot failed to use carburetor heat resulting in engine power loss due to carburetor ice. Factors were unsuitable terrain and obstructions.Jan 1, 1991 · N4675K · Substantial damageNTSB NYC91LA054Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Wildwood, NJThe pilot's failure to apply carburetor heat during the descent which resulted in a loss of engine power due to carburetor ice.Jan 1, 1991 · N81839 · Substantial damageNTSB LAX91LA064Accident · No injuriesLimited investigationFinal reportGrumman AA1B · Truckee, CA1) The pilots improper flare maneuver; 2) his failure to perform a bounced landing recovery; and 3) his failure to maintain directional control of the aircraft.Jan 1, 1991 · N1641R · Substantial damageNTSB DEN91LA030Accident · No injuriesLimited investigationFinal reportCessna 206A · Carlsbad, NMA loss of control by the pilot during landing roll due to his failure to maintain directional control.Jan 1, 1991 · N2691X · Substantial damage