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 MIA91LA121Accident · No injuriesLimited investigationFinal reportBeech A36 · Punta Gorda, FLDelay of the pilot to abort the takeoff from the private grass airstrip resulting in the airplane overrunning the runway and colliding with a ditch.Apr 11, 1991 · N7231L · Substantial damageNTSB LAX91LA177Accident · No injuriesLimited investigationFinal reportPiper PA28-236 · Gualala, CAThat the pilot failed to properly use the flight controls and to maintain directional control. Contributing to this accident were the gusty crosswind conditions that existed at the time of the accident.Apr 11, 1991 · N2915G · Substantial damageNTSB DEN91LA060Accident · No injuriesLimited investigationFinal reportCessna 172P · Lehi, ARThe pilot's failure to maintain aircraft control. Factors were: the wet runway and resultant hydroplaning.Apr 11, 1991 · N51254 · Substantial damageNTSB CHI91DEP04Accident · Minor injuriesFinal reportBrault Glasair SH2F · Green Bay, WIThe pilot in command's failure to refuel the aircraft prior to departure. A factor contributing to the accident was the unporting of the fuel pick up line in fuel tank during abrupt or negative 'g' maneuvers.Apr 11, 1991 · N1490 · Substantial damageNTSB SEA91IA081Incident · Minor injuriesIncident investigationFinal reportBoeing 737-222 · Seattle, WATurbine blade failure from fatigue. Factors to the incident were inoperative engine fire extinguisher, inadequate service of aircraft and delayed deployment of emergency slide.Apr 10, 1991 · N9003U · Minor damageNTSB NYC91LA111Accident · No injuriesLimited investigationFinal reportCessna 150G · Phillipsburg, OHThe failure of the pilot to compensate for crosswind conditions during landing, and allowing the airplane to drift off the runway onto soft terrain. A factor relating to the accident was the decision of the pilot to attempt a landing with strong crosswinds.Apr 10, 1991 · N3936J · Substantial damageNTSB MIA91LA120Accident · No injuriesLimited investigationFinal reportAeronca 7CCM · Lakeland, FLImproper ATC clearance by ground personnel and poor decision by the pilot to taxi behind an airplane holding on a runway.Apr 10, 1991 · N6040V · Substantial damageNTSB LAX91LA171Accident · No injuriesLimited investigationFinal reportPiper PA24-250 · Casa Grande, AZThat the pilot failed to maintain proper alignment during the landing roll on the narrow airstrip.Apr 10, 1991 · N7466P · Substantial damageNTSB FTW91LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Durant, OKThe pilot's failure to maintain proper alignment during the flare.Apr 10, 1991 · N116SS · Substantial damageNTSB CHI91LA129Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Griffith, INContaminated fuel in the carburetor, and inadequate inspection/maintenance of the airplane by the pilot in command.Apr 10, 1991 · N1375F · Substantial damageNTSB BFO91LA044Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · New Castle, DEThe pilot's failure to maintain directional control during the takeoff roll. Contributing to the accident was the unfavorable wind condition.Apr 10, 1991 · N2535N · Substantial damageNTSB NYC91FA115Accident · 2 fatalField investigationFinal reportCessna 172G · New Bedford, MAThe pilot's improper planning/decision and failure to maintain proper altitude after encountering adverse weather at low altitude. The adverse weather (fog) was a related factor.Apr 9, 1991 · N6005R · DestroyedNTSB LAX91LA168Accident · No injuriesLimited investigationFinal reportCessna 140 · El Mirage, CAThat the pilot made a poor inflight decision to practice the slow flight maneuver at a low altitude and that he failed to maintain airspeed.Apr 9, 1991 · N89572 · Substantial damageNTSB CHI91LA128Accident · No injuriesLimited investigationFinal reportDe Havilland Beaver U-6A · Oak Island, MNUnsuitable terrain was selected by the pilot. A factor related to the accident was the terrain/runway was composed of weak ice.Apr 9, 1991 · N9028 · Substantial damageNTSB CHI91FA126Accident · 2 fatalField investigationFinal reportBeech F.33A · Chippewa Falls, WIThe first pilot's continued flight in known adverse weather. Factors in the accident were the first pilot's poor weather evaluation, the second pilot's complacency and the first pilot's self induced pressure to complete a checkout in model.Apr 9, 1991 · N8012T · DestroyedNTSB BFO91LA043Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Morehead, KYThe pilot's operation of his aircraft in exceedingly high wind conditions.Apr 9, 1991 · N3781F · Substantial damageNTSB ANC91LA051Accident · Serious injuriesLimited investigationFinal reportAeronca 11AC · Kahiltna Glac., AKA downdraft and the pilot's inadequate remedial action.Apr 9, 1991 · N3436E · Substantial damageNTSB ANC91IA052Incident · No injuriesIncident investigationFinal reportPiper PA-32-301 · Eek, AKThe failure of the center torque link bolt.Apr 9, 1991 · N4258N · Minor damageNTSB ANC91FA050Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Tatitlek, AKFailure of both pilots to see-and-avoid each other (inadequate visual lookout). A factor related to the accident was: inadequate communication among all participating aircrews.Apr 9, 1991 · N6966D · 2 aircraft · Substantial damageNTSB MIA91LA119Accident · No injuriesLimited investigationFinal reportCessna 150L · Palm Bay, FLLoss of control during the landing roll due to failure of the pilot to apply aileron control to prevent the airplane from drifting off the runway due to a crosswind and failure to maintain directional control. Contributing to the accident was the pilot's lack…Apr 8, 1991 · N6657G · Substantial damageNTSB LAX91LA166Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Carefree, AZInadequate supervision by the certified flight instructor (CFI), an inadequate visual lookout by both pilots.Apr 8, 1991 · N5206T · DestroyedNTSB LAX91LA165Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Hemet, CAThe failure of the PIC to select a proper touch down point. Contributing to the accident was the lack of recent familiarity with the geographic layout of the landing area.Apr 8, 1991 · N2032T · Substantial damageNTSB LAX91LA164Accident · Serious injuriesLimited investigationFinal reportPiper PA 46 · North Hollywood, CAThe pilot-in-command's poor preflight planning, inadequate fuel consumption calculations which resulted in a loss of engine power due to fuel exhaustion, and the pilot-in-command's failure to follow air traffic control verbal instructions which would have…Apr 8, 1991 · N9113X · DestroyedNTSB ATL91LA078Accident · 1 fatalLimited investigationFinal reportLewis Challenger II · Thomaston, GAThe pilot's failure to properly maintain the airplane in accordance with prescribed procedures which resulted in fuel contamination, fouled spark plugs, and a loss of engine power. The pilot also failed to follow normal emergency procedures for the loss of…Apr 8, 1991 · N283EL · Substantial damageNTSB NYC91LA110Accident · No injuriesLimited investigationFinal reportCessna 182F · Carrabassett Vy, MEImproper use of the carburetor heat by the pilot which resulted in a power loss due to carburetor ice over unsuitable terrain.Apr 7, 1991 · N312OU · Substantial damageNTSB NYC91LA109Accident · No injuriesLimited investigationFinal reportCessna 150E · Walkill, NYAn inflight collision with terrain during an uncontrolled descent after the pilot parachuted from the airplane. Contributing to the accident were fuel exhaustion and the pilot's disregard for emergency procedures.Apr 7, 1991 · N3566J · DestroyedNTSB NYC91LA108Accident · No injuriesLimited investigationFinal reportCessna 402A · Albany, NYA collapse of the nose gear due to a failure of the nose gear trunion.Apr 7, 1991 · N104EC · Substantial damageNTSB NYC91LA105Accident · No injuriesLimited investigationFinal reportCessna 170B · Newburyport, MAThe pilot failing to compensate adequately for adverse wind conditions during takeoff.Apr 7, 1991 · N3108A · Substantial damageNTSB NYC91LA104Accident · Minor injuriesLimited investigationFinal reportPiper J-4A · Mahopac, NYThe erratic performance of the left magneto resulting in inadequate climb capabilities and in flight collision with terrain.Apr 7, 1991 · N23179 · Substantial damageNTSB NYC91FA103Accident · 1 fatalField investigationFinal reportBellanca 17-31 ATC · Gt. Barrington, MAThe mechanic's improper use of anti-seize compound on the injector nozzle threads which resulted in an engine failure.Apr 7, 1991 · N1269R · DestroyedNTSB MIA91LA118Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Green Cove Spgs, FLLoss of control while on approach to land due to failure of the pilot to maintain vs resulting in the airplane stalling and impacting the ground nose low.Apr 7, 1991 · N3025H · Substantial damageNTSB LAX91LA231Accident · No injuriesLimited investigationFinal reportSchleicher ASW-20 · Julian, CAThe pilot's failure to maintain control of his experimental glider during takeoff. A contributing factor was the pilot's encounter with gusty winds.Apr 7, 1991 · N31AP · Substantial damageNTSB LAX91LA163Accident · Minor injuriesLimited investigationFinal reportSchempp-Hirth Ventus B/16.6 · Lake Cobb, CAThat the pilot's visual lookout was improper. Contributing to this accident was the unmarked transmission wire.Apr 7, 1991 · N81PT · Substantial damageNTSB LAX91LA162Accident · No injuriesLimited investigationFinal reportHughes 369D · Yerington, NVThe pilot's excessive airspeed and rate of descent on final approach to land, and subsequent loss of rotor RPM while attempting to flare. The ditch was a related factor.Apr 7, 1991 · N1109Q · Substantial damageNTSB LAX91LA161Accident · Minor injuriesLimited investigationFinal reportRockwell 112TCA · Burbank, CAThat the pilot failed to properly preflight the airplane and miscalculated the airplane's fuel consumption. Contributing to this accident was fuel exhaustion.Apr 7, 1991 · N4632W · DestroyedNTSB CHI91LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · Oskosh, WIRefueling not performed resulting in loss of engine power due to fuel exhaustion. Factors related to the accident were misjudged fuel consumption calculations and non suitable terrain.Apr 7, 1991 · N24399 · Substantial damageNTSB BFO91LA041Accident · No injuriesLimited investigationFinal reportCessna 172P · College Park, MDThe pilot misjudged altitude and distance which resulted in an overrun of the runway.Apr 7, 1991 · N9671A · Substantial damageNTSB ATL91LA082Accident · No injuriesLimited investigationFinal reportCessna 172P · Hatteras, NCThe pilot's improper landing flare, subsequent inadvertent porpoise, and his failure to execute a bounced landing recovery.Apr 7, 1991 · N62340 · Substantial damageNTSB ATL91FA077Accident · 1 fatalField investigationFinal reportCessna 172D · Mocksville, NCThe loss of engine power due to open circuits in the ignition wiring harness, and the pilot's failure to maintain flying airspeed during the forced landing attempt. Factors in this accident were the dark night lighting conditions at the time of the accident.Apr 7, 1991 · N2936U · Substantial damageNTSB SEA91LA079Accident · No injuriesLimited investigationFinal reportGrumman American AA-1C · Wenatchee, WACarburetor ice as a result of the pilot's improper use of carburetor heat.Apr 6, 1991 · N9651U · DestroyedNTSB SEA91LA078Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Kent, WAThe pilot's inadequate remedial action to correct the imminent dynamic rollover. Factors to the accident were: the pilot's poorly planned approach and lack of totoal flight experience.Apr 6, 1991 · N24176 · Substantial damageNTSB NYC91LA116Accident · No injuriesLimited investigationFinal reportPiper 180 · Andes, NYThe failure of the pilot to maintain directional control during a landing with unfavorable winds.Apr 6, 1991 · N9006J · Substantial damageNTSB NYC91LA107Accident · Serious injuriesLimited investigationFinal reportEnstrom F28A · Leetonia, OHThe helicopter hover performance was exceeded by the pilot and his failure to perform a normal approach to a landing. Factors were the high winds and the tailwind condition.Apr 6, 1991 · N58KC · Substantial damageNTSB NYC91LA106Accident · No injuriesLimited investigationFinal reportCessna 172P · Burlington, CTThe failure of the pilot to maintain directional control during the landing. Factors related to the accident were: improper use of the flight controls by the pilot, his lack of recent experience and total time, and the crosswind.Apr 6, 1991 · N64182 · Substantial damageNTSB NYC91LA102Accident · 1 fatalLimited investigationFinal reportSchweizer SGS-1-30 · Wurtsboro, NYAn inflight failure of the left wing spar due to overload from pilot induced control inputs, while recovering from a dive. Factors related to the accident were, the pilot's decision to fly with the trim system disconnected and lack of recent experience in…Apr 6, 1991 · N3620D · DestroyedNTSB LAX91LA167Accident · No injuriesLimited investigationFinal reportCessna 414A · Avenal, CAThe failure of the pilot to maintain directional control after striking a dirt berm during the landing roll. Contributing to the accident was the failure of the pilot to ensure that the airport was adequate for his intended operations.Apr 6, 1991 · N242AR · Substantial damageNTSB LAX91LA160Accident · No injuriesLimited investigationFinal reportBurnett, Jerry D. Challenger II · Bullhead City, AZThe disintegration of the propeller. Contributing to this accident was the deterioration of aircraft control and the nonavilability of suitable landing terrain.Apr 6, 1991 · N4555J · Substantial damageNTSB FTW91LA062Accident · No injuriesLimited investigationFinal reportCessna A188B · Tipton, OKFailure of the pilot to maintain poroper clearance above obstacles. A factor was the sun glare.Apr 6, 1991 · N4165J · Substantial damageNTSB FTW91LA061Accident · Serious injuriesLimited investigationFinal reportCessna 150D · San Ygnacio, TXPower loss due to carburetor ice and a malfunctioning carburetor heat control and the pilot's loss of control of the airplane.Apr 6, 1991 · N4437U · DestroyedNTSB DEN91LA059Accident · No injuriesLimited investigationFinal reportBeech A36 · Salida, COThe dual student's poor takeoff technique, his failure to maintain directional control, and inadequate supervision by the PIC CFI. A factor was: the dual student's lack of experience in mountain flying.Apr 6, 1991 · N4595S · Substantial damage