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 FTW93IA067Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC8-55 · Dfw Airport, TXFailure of an engine turbine wheel for undetermined reasons.Jan 15, 1993 · N8041U · Minor damageNTSB FTW93FA068Accident · 2 fatalField investigationFinal reportCessna 150J · Porter, TXInadvertent stall. Factors were the pilot's failure to follow the published checklist and the improper flap settingJan 15, 1993 · N5563G · DestroyedNTSB BFO93FA050Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Ligonier, PAVisual flight rules (VFR) flight by the pilot into instrument meteorological conditions (IMC), and the pilot's failure to maintain sufficient altitude from the wooded terrain. The terrain and adverse weather conditions were related factors.Jan 15, 1993 · N28196 · DestroyedNTSB SEA93LA051Accident · No injuriesLimited investigationFinal reportBeech 58P · Hanksville, UTAn improper fuel selector valve position, fuel starvation, and inadequate remedial action. Factors include soft, rough terrain.Jan 14, 1993 · N550TH · Substantial damageNTSB CHI93LA071Accident · No injuriesLimited investigationFinal reportDon Showalter Lancair 320 · Madison, WIA jammed main landing gear brake.Jan 14, 1993 · N18M · Substantial damageNTSB BFO93LA021Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-108 · Manorhaven, NYThe partial power loss due to induction system icing and the pilots failure to apply carburetor heat during weather conducive to induction system icing.Jan 14, 1993 · CFAXE · Substantial damageNTSB ATL93LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Salisbury, NCThe pilot became lost and exhausted the airplane fuel supply.Jan 14, 1993 · N25865 · Substantial damageNTSB ATL93LA050Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Goldsboro, NCThe pilot's improper decision in attempting a night landing at an airport without operating runway lights which resulted in a touchdown off the runway. Factors which contributed to the accident were: an airplane lighting malfunction for an undetermined…Jan 14, 1993 · N8409A · Substantial damageNTSB LAX93FA093Accident · 2 fatalField investigationFinal reportBell 206B · Hayward, CAThe pilot's continued flight into known adverse weather conditions and continued VFR flight into instrument meteorological conditions. Contributing to the accident were dark night light conditions and rain.Jan 13, 1993 · N3202A · DestroyedNTSB FTW93LA066Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXThe pilot's inadequate flare and the improper recovery from a bounced landingJan 13, 1993 · N64949 · Substantial damageNTSB FTW93LA065Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Santa Fe, NMThe pilot's failure to maintain directional control. A factor was the snow conditionsJan 12, 1993 · N734GD · Substantial damageNTSB CHI93LA070Accident · Serious injuriesLimited investigationFinal reportAero Commander 500-B · Susank, KSThe pilot's continued flight into adverse weather and the owner's representation that the airplane met the requirements for flight into icing conditions. The weather and airframe ice were factors in the accident.Jan 12, 1993 · N712AC · Substantial damageNTSB SEA93IA050Incident · No injuriesIncident investigationFinal reportBeech 1900C · Riverton, WYThe pilot's disorientation. Factors include snow, fog, snow covered terrain, and a drainage ditch.Jan 11, 1993 · N34010 · Minor damageNTSB LAX93LA094Accident · No injuriesLimited investigationFinal reportCessna 150 · Torrance, CA1) The pilot misjudging the airplane's landing flare, and 2) the pilot's improper recovery from a bounced landing. A factor in this accident was the pilot's lack of total aircraft experience.Jan 11, 1993 · N6019T · Substantial damageNTSB BFO93FA019Accident · 2 fatalField investigationFinal reportHughes 269C · Tonawanda, NYImproper inflight planning/decision by the pilot and his failure to maintain clearance from an obstacle during flight. Factors related to the accident include poor visibility and weather conditions at dusk, and the pilot's excessive airspeed for the…Jan 11, 1993 · N1088Z · DestroyedNTSB FTW93IA064Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC9-82 · Dfw Airport, TXThe inaccurate safety advisory provided by the tower operator. A factor was the emergency evacuationJan 10, 1993 · N7532A · No damageNTSB BFO93LA020Accident · No injuriesLimited investigationFinal reportDornier DO-228-202 · Manchester, NHIncorrect installation of the seals in the nose gear assembly, which prevented the nose gear from locking in the down position.Jan 10, 1993 · N245RP · Substantial damageNTSB BFO93FA018Accident · 1 fatalField investigationFinal reportCessna 182P · Stow, MAAn inadequate preflight by the pilot, which allowed water contamination in the fuel and subsequent loss of engine power; and failure of the pilot to maintain adequate airspeed, which resulted in a stall.Jan 10, 1993 · N52785 · DestroyedNTSB MIA93LA047Accident · 1 fatalLimited investigationFinal reportCessna 337H · New Smyrna Bch, FLThe pilot-in-command's failure to maintain altitude while maneuvering in a turn at a low altitude, resulting in an in-flight collision with the ocean.Jan 9, 1993 · N1443S · DestroyedNTSB DEN93LA022Accident · No injuriesLimited investigationFinal reportCessna T210L · Monte Vista, COA loss of control during landing when the aircraft struck a snowbank which was left on the runway as a result of inadequate plowing.Jan 9, 1993 · N96LL · Substantial damageNTSB DEN93IA025Incident · No injuriesIncident investigationFinal reportBoeing 767-222 · Denver, COMedical incapacitation of the first officer.Jan 9, 1993 · N601UA · No damageNTSB CHI93LA067Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · La Pointe, WISpatial disorientation of the pilot.Jan 9, 1993 · N7057B · Substantial damageNTSB CHI93IA069Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-311 · Savoy, ILThe total failure of the inboard right main landing gear wheel axle during the initial climb.Jan 9, 1993 · N433AW · Minor damageNTSB LAX93LA091Accident · Serious injuriesLimited investigationFinal reportCessna 172 · San Jacinto, CAThe flight's encounter with unforecast clear air turbulence.Jan 8, 1993 · N20513 · DestroyedNTSB CHI93IA068Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-102 · Detroit, MIThe manufacturer's inadequate design of the fuel transfer tube system, which loosened/disconnected during engine operation.Jan 8, 1993 · N826MA · No damageNTSB SEA93GA049Accident · No injuriesFinal reportPiper PA-18-135 · Council, IDThe pilot's failure to maintain proper altitude during the low pass. The snow covered terrain and the pilot's inadequate preflight preparation were factors.Jan 7, 1993 · N9841Q · Substantial damageNTSB CHI93LA066Accident · Minor injuriesLimited investigationFinal reportCessna 310R-II · Marysville, KSThe pilot's failure to maintain sufficient airspeed. Factors contributing to the accident were the icing conditions encountered, and the windshield & airframe ice.Jan 7, 1993 · N8016M · DestroyedNTSB ANC93IA026Incident · No injuriesIncident investigationFinal reportGrumman G-21A · Akutan, AKThe incident was caused by the pilots improper compensation for the winds. Factors were the microburst, the rough water, and the pilot's inadequate evaluation of the weather conditions.Jan 7, 1993 · N22932 · Minor damageNTSB MIA93LA048Accident · Minor injuriesLimited investigationFinal reportPiper PA-23 · Tampa, FLPoor in-flight planning/decision by the CFI resulting in the total loss of engine power from both engines due to fuel exhaustion.Jan 6, 1993 · N1439P · Substantial damageNTSB MIA93LA046Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Holly Springs, MSThe pilot-in-command's failure to maintain airspeed while maneuvering during a forced landing, resulting in an in-flight loss of control (stall), and subsequent collision with terrain. Contributing to the accident was a total loss of engine power in flight…Jan 6, 1993 · N22761 · Substantial damageNTSB CHI93LA065Accident · No injuriesLimited investigationFinal reportCessna 172N · Warren, MNThe student pilot's failure to maintain directional control.Jan 6, 1993 · N6176G · Substantial damageNTSB ANC93LA025Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-35 · Nome, AKFuel starvation due to improper refueling procedures by the FBO personnel, inadequate preflight by the pilot, and resultant ice in the fuel, which blocked fuel flow to the engines. A factor was the lack of suitable terrain for a forced landing.Jan 6, 1993 · N900YH · Substantial damageNTSB MIA93LA045Accident · Serious injuriesLimited investigationFinal reportBoeing 767-323ER · Sarasota, FLThe in-flight encounter with weather and the failure of the passengers to comply with the instructions of the flightcrew.Jan 5, 1993 · N360AA · Minor damageNTSB FTW93LA062Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Wichita Falls, TXThe pilot's failure to maintain directional control.Jan 5, 1993 · N4870B · Substantial damageNTSB CHI93LA064Accident · No injuriesLimited investigationFinal reportCessna T210K · Metropolis, ILThe fatigue failure of the exhaust valve.Jan 5, 1993 · N732FB · Substantial damageNTSB ANC93LA024Accident · Minor injuriesLimited investigationFinal reportCessna 207A · Scammon Bay, AKThe pilots failure to follow VFR procedures. A factor was the whiteout snow condition.Jan 5, 1993 · N7373U · Substantial damageNTSB CHI93FA063Accident · 3 fatalField investigationFinal reportCessna T337G · Smiths Creek, MIThe pilot-in-command's failure to maintain control of the airplane during the approach. Factors which contributed to the accident were the adverse weather conditions and the dark night.Jan 4, 1993 · N1ZD · DestroyedNTSB SEA93FA048Accident · 4 fatalField investigationFinal reportBell 206B3 · Ogden, UTThe pilot's continuation of VFR flight into instrument meteorological conditions, and his decision to continue his landing attempts under the adverse weather conditions. Factors contributing to the accident were the low clouds, fog and mountainous terrain.Jan 3, 1993 · N1078V · DestroyedNTSB MIA93LA044Accident · No injuriesLimited investigationFinal reportBeech 1900D · Fort Myers, FLFailure of the pilot-in-command to follow the checklist and complacency of the pilot-in-command for failure to extend the landing gear before landing.Jan 3, 1993 · N18YV · Substantial damageNTSB CHI93MA061Accident · No injuriesMajor investigationFinal reportSaab-Scania 340A · Hibbing, MNThe first officer's failure to maintain a proper descent rate during the landing, and the captain's inadequate supervision by not taking timely action to ensure a safe landing. Factors which contributed to the accident were: the company's failure to provide…Jan 3, 1993 · N342PX · Substantial damageNTSB CHI93LA062Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Milwaukee, WIFailure of the pilot to perform an aborted landing and failure to select a proper touchdown point on the runway.Jan 3, 1993 · N1801V · Substantial damageNTSB ATL93LA047Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Roanoke Rapids, NCThe pilot-at-control's failure to use carburetor heat resulting in a loss of engine power due to carburetor ice. A factor which contributed to the accident was weather conducive to carburetor ice.Jan 3, 1993 · N8024T · Substantial damageNTSB ATL93FA046Accident · 2 fatalField investigationFinal reportBeech A23 · Ft. Bragg, NCThe loss of engine power for undetermined reasons and the loss of control during the forced landing.Jan 3, 1993 · N5774V · DestroyedNTSB MIA93WA043Accident · No injuriesForeign investigationPiper PA-31-350 · Bimini, BahamasJan 2, 1993 · N4107V · DestroyedNTSB MIA93IA052Incident · Minor injuriesIncident investigationFinal reportBalloon Works Firefly 7-15 · Orlando, FLPoor in-flight planning/decision by the pilot, and excessive descent resulting in a hard landing.Jan 2, 1993 · N9056D · No damageNTSB LAX93LA089Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Gorman, CA1) The carburetor inlet fuel line being improperly installed by maintenance personnel which allowed the carburetor to become contaminated with metal particles, and 2) the carburetor float valve being jammed by metal particles which allowed excessive fuel to…Jan 2, 1993 · N6790V · Substantial damageNTSB LAX93LA088Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201T · Concord, CAThe engine manufacturer failing to properly install tab washers during overhaul which resulted in one bolt becoming loose and being ingested through various engine gear drives. The ingestion and loose oil pump cover resulted in the engine running rough and a…Jan 2, 1993 · N2008M · Substantial damageNTSB LAX93LA087Accident · Serious injuriesLimited investigationFinal reportHughes 269C · Folsom, CAThe pilot failing to maintain an adequate visual lookout resulting in the helicopter colliding with electrical transmission wires.Jan 2, 1993 · N7462F · DestroyedNTSB BFO93LA017Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Philipsburg, PAThe inadequate removal of snow from the runways by airport personnel and the procedures/directives for airport snow removal not understood.Jan 2, 1993 · N15141 · Substantial damageNTSB ATL93LA049Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Crossville, TNThe pilot's failure to follow checklist procedures in that he did not utilize the alternate gear extension method when electrical power was lost. A factor was his failure to follow the checklist when he failed to turn on the generators prior to flight, which…Jan 2, 1993 · N7712Y · Substantial damage