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 LAX92LA095Accident · No injuriesLimited investigationFinal reportCessna 150J · Pinyon, CAThe flight instructor's inadequate in-flight planning to enter a mountainous area at a low altitude, and his improper handling of the airplane. Factors which contributed to the accident related to the instructor's lowering of the wing flaps during a time when…Jan 19, 1992 · N50810 · Substantial damageNTSB LAX92FA094Accident · 2 fatalField investigationFinal reportMooney M-20-C · Santa Monica, CAFuel contamination by water due to the; 1) failure of the fuel caps to properly seal against water ingestion, 2) the pilots failure to adequately perform a preflight inspection of the aircraft sufficient to detect the presence of water in the fuel tanks.…Jan 19, 1992 · N6481U · DestroyedNTSB CHI93LA381Accident · No injuriesLimited investigationFinal reportCessna 172 · Union Center, SDImproper planning/decision by the pilot, and his failure to abort the takeoff, while there was sufficient runway remaining. Factors related to the accident were: the soft runway condition & fence at the end of the runway.Jan 19, 1992 · N8529U · Substantial damageNTSB CHI92LA103Accident · No injuriesLimited investigationFinal reportCessna 182P · Monee, ILThe pilot misjudged the landing flare and touchdown. A related factor was: the dark night light conditions.Jan 19, 1992 · N7529N · Substantial damageNTSB CHI92LA076Accident · No injuriesLimited investigationFinal reportCessna 414 · Gaylord, MIDirectional control was not maintained by the pilot. Factors related to the accident were: airport snow removal had not been performed by the airport personnel, a dark night with falling snow and the snowbank on the runway.Jan 19, 1992 · N6814R · Substantial damageNTSB CHI92LA075Accident · No injuriesLimited investigationFinal reportCessna 152 · Zenda, WIDirectional control was not maintained by the pilot. Factors related to the accident were: a gusty surface wind condition and lack of total experience by the pilot.Jan 19, 1992 · N68430 · Substantial damageNTSB CHI92LA074Accident · No injuriesLimited investigationFinal reportCessna 175 · Warren, MIA loss of engine power as a result of a connecting rod failure. Factors related to the accident were the power lines and trees in the path of the selected emergency landing site.Jan 19, 1992 · N8293T · Substantial damageNTSB SEA92LA038Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Chehalis, WAThe failure of the pilot to attain the proper touchdown point for landing. A factor relating to the accident was the poor braking conditions on the wet grass strip.Jan 18, 1992 · N39298 · Substantial damageNTSB DEN92FA028Accident · No injuriesField investigationFinal reportBeech 35 · Nucla, COImproper static balance of the ruddervators following rebuilding/repainting, which resulted in empennage flutter.Jan 18, 1992 · N3342V · Substantial damageNTSB CHI92LA073Accident · No injuriesLimited investigationFinal reportCessna 177RG · Indianapolis, INEngine loss of power for undetermined reasons. The lack of suitable terrain for a forced landing was a factor.Jan 18, 1992 · N8013G · Substantial damageNTSB BFO92FA020Accident · Serious injuriesField investigationFinal reportDouglas DC-9-30 · Horseheads, NYThe aircraft encountered a sudden wind gust during landing flare, which resulted in a hard landing.Jan 18, 1992 · N964VJ · Substantial damageNTSB BFO92LA023Accident · No injuriesLimited investigationFinal reportCessna 182-D · Put In Bay, OHThe pilot's failure to maintian directional control during landing. Contributing to the accident were the snow on the runway and the gusty winds.Jan 17, 1992 · N9042X · Substantial damageNTSB DEN92LA026Accident · No injuriesLimited investigationFinal reportCessna 172P · Englewood, COLoss of directional control when the student pilot inadvertently activated the brakes during takeoff roll. Inadequate supervision by the certified flight instructor was a factor.Jan 16, 1992 · N65513 · Substantial damageNTSB ATL92FA040Accident · 2 fatalField investigationFinal reportCessna 140 · Columbia, SCThe pilot-in-command's failure to assure that an adequate supply of fuel was on board the airplane for the intended flight, and his failure to maintain adequate airspeed during the forced landing resulting in a stall/spin. A factor contributing to the…Jan 16, 1992 · N1976N · Substantial damageNTSB MIA92LA064Accident · No injuriesLimited investigationFinal reportHughes 369D · Pompano Beach, FLImproper collective input by the pilot-in-command and inadequate supervision by the check pilot.Jan 15, 1992 · N5119N · Substantial damageNTSB BFO92FA022Accident · 1 fatalField investigationFinal reportHughes 369D · Edison, NJThe blockage of the fuel nozzle which resulted in partial loss of engine power. Contributing was the pilot's failure to maintain rotor RPM.Jan 15, 1992 · N8674F · DestroyedNTSB ANC92IA029Incident · No injuriesIncident investigationFinal reportCessna 207 · Port Moller, AKThe icy and snow covered condition of the runway surface and the pilot's inadequate preflight planning and preparation by not surveying the surface of the entire runway.Jan 15, 1992 · N70076 · Minor damageNTSB SEA92LA039Accident · 1 fatalLimited investigationFinal reportErcoupe 415-C · Hansville, WAThe inadequate preflight preparation and improper inflight decision by the student pilot who was not qualified to conduct the flight. A factor relating to the accident was the adverse weather conditions.Jan 14, 1992 · N86964 · DestroyedNTSB LAX92LA093Accident · 5 fatalLimited investigationFinal reportCessna 310Q · Honolulu, HIThe pilot's continuation of VFR flight into instrument meteorological conditions resulting in spatial disorientation and loss of aircraft control. Factors which contributed to the accident were: the adverse weather conditions and the pilot's failure to obtain…Jan 14, 1992 · N787AM · DestroyedNTSB FTW92LA057Accident · No injuriesLimited investigationFinal reportCessna 172N · Albuquerque, NMThe pilot's failure to maintain directional control during landing. A factor was his lack of total experience.Jan 14, 1992 · N4885G · Substantial damageNTSB FTW92LA056Accident · No injuriesLimited investigationFinal reportCessna 205A · Spring, TXThe partial power loss due to cylinder fatigue and resultant engine vibrations. Factors were the oil covered windshield restricting the pilot's vision and the wet terrain.Jan 14, 1992 · N8352Z · Substantial damageNTSB SEA92LA037Accident · No injuriesLimited investigationFinal reportCessna 150L · Tacoma, WAThe pilot's improper use of remedial action when he encountered carburetor icing. Factors include carburetor ice and carburetor icing conditions.Jan 13, 1992 · N11632 · Substantial damageNTSB MIA92LA061Accident · 1 fatalLimited investigationFinal reportCessna 172G · Atlantic Ocean (Atlantic Ocean)Loss of engine power due to undetermined reasons.Jan 13, 1992 · N121L · Substantial damageNTSB MIA92FA062Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Homestead, FLThe non-instrument rated pilot's continued VFR flight into instrument flight conditions resulting in spatial disorientation and inflight loss of control.Jan 13, 1992 · N2606Y · DestroyedNTSB LAX92FA092Accident · 2 fatalField investigationFinal reportCessna T210L · Temple Bar, AZFatigue failure of the turbocharger's turbine shaft due to inadequate maintenance, and the pilot's improper in-flight planning/decision after experiencing a turbocharger failure. A factor related to the accident was: the lack of information in the pilot…Jan 13, 1992 · N22592 · DestroyedNTSB CHI92LA071Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Grand Rapids, MNThe pilot's lack of familiarity with aircraft systems which resulted in his failure to extend the landing gear by the alternate system. A factor was the loss of engine power.Jan 13, 1992 · N255W · Substantial damageNTSB BFO92LA019Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Bowling Green, KYThe pilot's premature flare, stalling the airplane which resulted in a hard landing. Factors related to the accident were the dual fuel flow gauge failures and deteriorating weather conditions.Jan 13, 1992 · N9161K · Substantial damageNTSB ATL92FA039Accident · 5 fatalField investigationFinal reportCessna 421C · Atlantic Ocean (Atlantic Ocean)The pilot's inadequate weather evaluation, and his continued flight into known adverse weather conditions. Factors were: the improper weather briefing by a flight service station specialist, and level iii thunderstorms.Jan 13, 1992 · N40JK · DestroyedNTSB MIA92LA063Accident · No injuriesLimited investigationFinal reportBeech 58 · West Palm Beach, FLPartial failure of the landing gear motor which caused internal damage to the landing gear retract motor and gearbox assy.Jan 12, 1992 · N4188S · Substantial damageNTSB LAX92LA089Accident · No injuriesLimited investigationFinal reportCessna 172N · Show Low, AZThe failure of the carburetor heat box attach straps which allowed the carburetor heat box to separate from the exhaust system heat muff and rendered the carburetor heat system inoperative. The engine then lost power due to carburetor ice.Jan 12, 1992 · N1571E · Substantial damageNTSB LAX92FA090Accident · 7 fatalField investigationFinal reportCessna 425 · Las Vegas, NVThe pilot's failure to maintain aircraft control due to spatial disorientation. Factors in this accident were: 1) the pilot's failure to obtain a preflight weather briefing and to properly evaluate the existing weather conditions prior to flight, and 2)…Jan 12, 1992 · N425BN · DestroyedNTSB BFO92LA018Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Richmond, RIThe pilots failure to maintain directional control during rollout.Jan 12, 1992 · N9483T · Substantial damageNTSB BFO92IA017Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-102 · Baltimore, MDImproper installation of the low fuel pressure warning switch snubber on the #1 engine, resulting in fatigue failure of the snubber, a fuel leak (spray), and subsequent explosion/fire damage. A factor related to the incident was: inadequate design of the…Jan 12, 1992 · N923HA · Minor damageNTSB ATL92LA038Accident · No injuriesLimited investigationFinal reportBeech J-35 · Knoxville, TNThe manufacturer's failure to provide adequate torque information which resulted in the loss of torque on the cylinder hold down nuts and the complete loss of engine power.Jan 12, 1992 · N185Y · Substantial damageNTSB ATL92LA037Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Griffin, GAThe excessive speed used by the pilot to land on the short private airstrip. A factor was unfavorable wind.Jan 12, 1992 · N6101D · Substantial damageNTSB MIA92FA059Accident · 2 fatalField investigationFinal reportCessna 150L · Lake Alfred, FLThe pilot-in-command's inadvertent accelerated stall while buzzing at an altitude that precluded recovery.Jan 11, 1992 · N6032J · DestroyedNTSB MIA92FA058Accident · 1 fatalField investigationFinal reportCessna 402B · Lantana, FLThe pilot in commands failure to maintain airspeed above single engine minimum control speed resulting in an inflight loss of control and collision with terrain. Contributing to the accident was the pilot in command's failure to declare an emergency and…Jan 11, 1992 · N3767C · DestroyedNTSB LAX92LA098Accident · No injuriesLimited investigationFinal reportMooney M20J · Bullhead City, AZThe pilot of the other aircraft inadvertently landing on the taxiway instead of the active runway.Jan 11, 1992 · N7000L · 2 aircraft · Substantial damageNTSB LAX92LA087Accident · No injuriesLimited investigationFinal reportRobinson R22B · Lake Hughes, CAThe failure of the pilot to maintain rotor RPM while maneuvering and his misjudgement of the landing flare. A factor in the accident was the pilot's lack of total experience.Jan 11, 1992 · N2634N · Substantial damageNTSB LAX92FA088Accident · 5 fatalField investigationFinal reportBell 206BIII · Crockett, CAThe pilot's failure to maintain vigilant watch for obstructions while intentionally cruising slowly at a low altitude. A factor was the power line was supported by distant towers, and the line was not conspicuous.Jan 11, 1992 · N95AT · DestroyedNTSB CHI92LA072Accident · No injuriesLimited investigationFinal reportBeech A36 · Griffith, INPremature gear retraction during takeoff roll by the pilot.Jan 11, 1992 · N15PM · Substantial damageNTSB CHI92LA069Accident · No injuriesLimited investigationFinal reportCessna 182 · Lake Elmo, MNThe proper touchdown point was not attained and an aborted landing was delayed by the pilot. A factor related to the accident was the icy runway conditions.Jan 11, 1992 · N9845H · Substantial damageNTSB ATL92LA036Accident · Serious injuriesLimited investigationFinal reportMosley HS GN-1 · Cullman, ALThe pilot's failure to maintain a safe flying speed.Jan 11, 1992 · N3202F · Substantial damageNTSB ATL92LA035Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Millen, GAThe pilot's failure to properly use carburetor heat during icing conditions which resulted in the formation of carburetor ice and subsequent loss of engine power.Jan 11, 1992 · N5866R · Substantial damageNTSB SEA92LA058Accident · No injuriesLimited investigationFinal reportCessna 207 · Seattle, WAThe cargo door unlatched for undetermined reasons.Jan 9, 1992 · N91056 · Substantial damageNTSB LAX92WA091Accident · Serious injuriesForeign investigationBoeing 747-100 · Narita, JapanJan 9, 1992 · N4729U · No damageNTSB ANC92LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Anchorage, AKThe failure of the pilot to maintain directional control of the airplane during the aborted takeoff. Contributing to the accident were the partial loss of engine power for undetermined reasons, the icy runway condition, and the pilot's lack of total…Jan 9, 1992 · N69004 · Substantial damageNTSB MIA92LA057Accident · 1 fatalLimited investigationFinal reportWalter R. Penney VARI-EZE · Lamar, MSThe pilot in commands departure into and continued flight in instrument meteorological conditions while operating under visual flight rules resulting in an inflight collision with trees and then the ground.Jan 8, 1992 · N12WP · DestroyedNTSB LAX92LA084Accident · No injuriesLimited investigationFinal reportCessna 172H · Arcata, CACarburetor icing and the failure of the pilot to use carburetor heat.Jan 8, 1992 · N1608F · Substantial damageNTSB CHI92IA068Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE-ATP · Fort Wayne, INFailure of company maintenance personnel to maintain the airplane in accordance with existing service bulletins.Jan 8, 1992 · N852AW · No damage