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 LAX90DXQ01Accident · Minor injuriesFinal reportBennet Spezio Tuholer · Chilcoot, CAThe pilot's improper inflight decision by failing to maintain proper terrain clearance while maneuvering near the ground to observe some deer.Dec 15, 1989 · N8841 · DestroyedNTSB ANC90FA020Accident · No injuriesField investigationFinal reportBoeing 747-400 · Anchorage, AKInadvertent encounter with volcanic ash cloud, which resulted in damage from foreign material (foreign object) and subsequent compressor stalling of all engines. A factor related to the accident was: the lack of available information about the ash cloud to…Dec 15, 1989 · PHBFC · Substantial damageNTSB LAX90LA051Accident · No injuriesLimited investigationFinal reportCessna 172 · Monterey, CAPilot misjudged clearance between the aircraft's wing tip & the fuel truck. A factor related to the accident was: the proximity of the vehicle (fuel truck).Dec 14, 1989 · N739EQ · Substantial damageNTSB FTW90TL#01Accident · No injuriesClass 3Final reportHughes 369E · Stroud, OKDec 14, 1989 · N600TP · Substantial damageNTSB CHI90IA044Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-31 · Chicago, ILInadequate snow removal by airport personnel.Dec 14, 1989 · N8969E · Minor damageNTSB MKC90LA039Accident · No injuriesLimited investigationFinal reportBeech 80 · Cape Girardeau, MOAn inoperative landing gear extension system due to failure of an electric motor and a misplaced emergency crank handle.Dec 13, 1989 · N525GT · Substantial damageNTSB SEA90LA029Accident · No injuriesLimited investigationFinal reportAero Commander 600 S-2D · Walla Walla, WAAn engine loss of power for undetermined reasons. Contributing to the accident was the embankment.Dec 11, 1989 · N1767S · DestroyedNTSB LAX90LA081Accident · No injuriesLimited investigationFinal reportCessna 414 · Bullhead City, AZThe pilot's failure to maintain sufficient clearance between his aircraft and ground objects during a taxi to the ramp area.Dec 11, 1989 · N8247Q · Substantial damageNTSB LAX90DJA02Accident · Minor injuriesFinal reportBryce Duster BJ-1B · Haleiwa, Oahu, HIThe separation in flight of the vertical wood fin from the main structure. It was not determined if the separation was due to overload forces or fatigue.Dec 11, 1989 · N25601 · Substantial damageNTSB FTW90IA043Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Baton Rouge, LAThe captain's excessive speed during a turn off of the runway, and his failure to maintain directional control. The wet taxiway was a related factor.Dec 11, 1989 · N416AA · No damageNTSB ANC90LA018Accident · Minor injuriesLimited investigationFinal reportCessna 402 · Kotzebue, AKPhysical impairment of the vehicle driver, from consumption of alcohol, which resulted in a collision with the airplane. The vehicle and dark night were considered to be related factors.Dec 11, 1989 · N67941 · Substantial damageNTSB CHI90LA069Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · West Chicago, ILFailure of the solo student pilot to maintain directional control of the aircraft, which resulted in an inadvertent ground swerve. Factors related to the accident were: the crosswind, the student pilot's lack of total inexperience, and the runway lights.Dec 10, 1989 · N4372S · Substantial damageNTSB CHI90LA041Accident · No injuriesLimited investigationFinal reportCessna 172N II · Middleton, WIThe pilot's improper use of flaps to provide lift on short final approach instead of applying power and the failure to maintain aircraft control.Dec 10, 1989 · N75912 · Substantial damageNTSB CHI90DEV01Accident · Minor injuriesFinal reportCessna 210D · Jerseyville, ILA total loss of engine power for an undetermined reason. A factor in the accident was the rough uneven terrain in the forced landing area.Dec 10, 1989 · N3955Y · Substantial damageNTSB ATL90FA038Accident · 3 fatalField investigationFinal reportCessna T210N · Spindale, NCThe pilot-in-command's improper IFR procedure which resulted in descent below the minimum descent altitude. Contributingfactor(s) was: the fog and low ceiling.Dec 10, 1989 · N5417C · DestroyedNTSB ANC90LA019Accident · No injuriesLimited investigationFinal reportMaule M-5 · Becky Lake, AKFatigue failure of the ski attach fitting due to being fabricated locally from the wrong steel which resulted in the airplane nosing over.Dec 10, 1989 · N6220M · Substantial damageNTSB NYC90LA037Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Uxbridge, MAIce in the fuel strainer, which restricted fuel flow & resulted in fuel starvation, and the pilot inadvertently stalled the airplane, when he abruptly maneuvered it to avoid a transmission wire during a forced landing.Dec 9, 1989 · N4289L · DestroyedNTSB NYC90FA038Accident · No injuriesField investigationFinal reportBoeing 727-31 · Newark, NJThermal distress of the first stage turbine blades of the nuber one engine causing a degradation of material properties which resulted in blade fractures. The reason for the thermal distress was not determined.Dec 9, 1989 · N727PJ · Substantial damageNTSB LAX90LA050Accident · No injuriesLimited investigationFinal reportHughes 369HS · Waimea, HIThe improper installation of the pc tube by company maintenance personnel, which resulted in fatigue failure of the tube due to induced bending stresses.Dec 9, 1989 · N9161F · Substantial damageNTSB CHI90LA042Accident · No injuriesLimited investigationFinal reportBeech V35 · Cable, WIThe pilot's failure to adequately compensate for crosswind conditions. Contributing to the accident was the gusty, crosswind conditions which existed.Dec 9, 1989 · N7988M · Substantial damageNTSB CHI90FA040Accident · 4 fatalField investigationFinal reportCessna 172M · Linden, MIThe failure of the pilot to maintain sufficient speed for flight. A factor associated with the accident was the pilot's operation of the airplane above the maximum allowable gross weight.Dec 9, 1989 · N1326U · DestroyedNTSB BFO90LA016Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Morgantown, WVThe pilot's excessive taxi speed. Ice on the ramp and the location of the fence were related factors.Dec 9, 1989 · N7485L · Substantial damageNTSB SEA90FA028Accident · 2 fatalField investigationFinal reportCessna 210-5 (205) · Rainier, WAContinued flight by the pilot into known adverse weather conditions, and his failure to maintain sufficient altitude/clearance from wooded mountainous terrain. Factors related to the accident were: darkness and the weather/terrain conditions.Dec 8, 1989 · CFOXF · DestroyedNTSB MIA90IA038Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-51 · Tallahassee, FLFailure of the first officer to properly align the aircraft for landing, and the captain's delay in taking remedial action.Dec 8, 1989 · N404EA · Minor damageNTSB ANC90LA028Accident · No injuriesLimited investigationFinal reportCessna 182 · Chakachamna Lk, AKInadequate preflight preparation of the takeoff area by the pilot, and his attempt to take off on unsuitable terrain. The soft/snow covered terrain was considered to be a contributing factor.Dec 8, 1989 · N8849T · Substantial damageNTSB ANC90LA016Accident · No injuriesLimited investigationFinal reportCessna 180 · Alexander Lake, AKSelection of unsuitable terrain by the pilot. The snow covered terrain was a related factor.Dec 8, 1989 · N9418C · Substantial damageNTSB MIA90LA037Accident · 1 fatalLimited investigationFinal reportCessna 172 · Atlantic Ocean (Atlantic Ocean)The engine seized from oil starvation (lack of oil or oil pressure), which resulted in the aircraft being ditched at sea.Dec 7, 1989 · N8785B · DestroyedNTSB LAX90LA047Accident · No injuriesLimited investigationFinal reportCessna 182E · Avalon, CAFailure of the pilot to attain the proper touchdown point for landing, and his failure to go around when he had too much speed and insufficient distance to stop on the runway. A factor related to the accident was: the uneven terrain beyond the departure end…Dec 7, 1989 · N2957Y · Substantial damageNTSB LAX90LA049Accident · No injuriesLimited investigationFinal reportCessna 150D · Inyokern, CAThe pilot's failure to use carburetor heat when climatic conditions were conducive to the formation of carburetor ice.Dec 6, 1989 · N4390U · Substantial damageNTSB ATL90LA037Accident · No injuriesLimited investigationFinal reportBeech A36 · Charlotte, NCThe failure of the airplane engine due to fuel exhaustion over terrain unsuitable for the forced landing.Dec 6, 1989 · N2997S · Substantial damageNTSB ATL90LA035Accident · Serious injuriesLimited investigationFinal reportWaco HRE · Alexander City, ALAn engine failure due to separation of the magneto as a result of a broken mounting stud. The mounting stud most likely failed due to vibrations induced by an inadequately balanced crankshaft.Dec 6, 1989 · N31654 · Substantial damageNTSB FTW90LA042Accident · No injuriesLimited investigationFinal reportPiper PA-34 · Tomball, TXCollapse of the nose gear for an undetermined reason.Dec 5, 1989 · N8426B · Substantial damageNTSB LAX90LA045Accident · No injuriesLimited investigationFinal reportNorth American P-51D · Van Nuys, CAThe P-51 pilot's failure to see and avoid the standing C-172.Dec 4, 1989 · N5415V · 2 aircraft · Minor damageNTSB FTW90LA041Accident · Serious injuriesLimited investigationFinal reportBell 47D1 · Ardmore, OKPilot's inadequate compensation for existing wind conditions. Contributing to the accident were the gusty tail winds.Dec 4, 1989 · N2202C · Substantial damageNTSB FTW90LA039Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Stephenville, TXThe pilot's failure to maintain adequate airspeed during a go-around which resulted in a stall.Dec 4, 1989 · N150RA · DestroyedNTSB MIA90RA034Accident · No injuriesForeign investigationDouglas DC-6B · George Town, BahamasDec 3, 1989 · N371NTSB MIA90LA035Accident · No injuriesLimited investigationFinal reportCessna 152 · Zephyrhills, FLThe student pilot not obtaining the current wind information which resulted in selecting the wrong runway for landing; improper recovery from a bounced landing. Contributing factor(s) was: the student pilot's lack of experience and the tailwind conditions.Dec 3, 1989 · N6479P · Substantial damageNTSB LAX90LA044Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Rialto, CAThe pilot's failure to maintain directional control during landing. Contributing factors were the gusty crosswind conditions.Dec 3, 1989 · N334K · Substantial damageNTSB DEN90LA032Accident · 1 fatalLimited investigationFinal reportPiper PA-18-150 · Powderville, MTThe pilot in command left the airplane unattended with the engine running. That the pilot's son did not understand the unsafe condition is considered a contributing factor.Dec 3, 1989 · N62672 · No damageNTSB DEN90LA031Accident · No injuriesLimited investigationFinal reportCessna 172 · Colorado Spgs, COThe pilot in command attempted a takeoff with the fuel mixture full rich, with a high density altitude, resulting in a partial loss of engine power during initial climb.Dec 3, 1989 · N6251E · Substantial damageNTSB CHI90LA036Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Waynesville, OHThe dual student did not maintain proper glidepath and his misjudgment for compensation for wind conditions resulted in a collision with utility wires. The cfi's inadequate supervision during the duel flight operation contributed to the accident.Dec 3, 1989 · N2610H · Substantial damageNTSB ATL90LA034Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Jackson, TNLoss of power in both engines (probable fuel starvation) due to improper planning/decision by the pilot(s), and lack of supervision by the instructor. Soft terrain in the emergency landing area was considered to be a factor.Dec 3, 1989 · N1361P · Substantial damageNTSB NYC90LA031Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Simsbury, CTThe pilot's misjudgement of airspeed and distance during landing resulting in an overshoot and swerve off the runway. The dusk light conditions, snow, and frozen terrain were contributing factors to the accident.Dec 2, 1989 · N2823T · Substantial damageNTSB LAX90LA048Accident · Serious injuriesLimited investigationFinal reportAerostar RX-7 · Chandler, AZImproper planning/decision by the pilot. Factors related to the accident were: variable and high wind conditions.Dec 2, 1989 · N64997 · Substantial damageNTSB LAX90LA046Accident · No injuriesLimited investigationFinal reportPiper PA-32-437 · Hayward, CAEngine failure due to water in fuel that was not discovered by the pilot during his preflight inspection of the fuel system.Dec 2, 1989 · N3350W · Substantial damageNTSB LAX90LA043Accident · No injuriesLimited investigationFinal reportCessna 140 · Concord, CAImproper use of the brakes by the pilot. The crosswind and the pilot's failure to maintain runway alignment were contributing factors.Dec 2, 1989 · N2065N · Substantial damageNTSB LAX90LA042Accident · Minor injuriesLimited investigationFinal reportBell 47G-II · Rialto, CAThe pilot's loss of directional control and subsequent overcontrol while hovering. Contributing to the accident were the gusty wind conditions and the pilot's inexperience.Dec 2, 1989 · N2899B · DestroyedNTSB DEN90LA029Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Grand Forks, NDFailure of the CFI to utilize carburetor heat prior to the induction icing and power loss. Contributing to the accident was the cfi's continued VFR flight into known and forecast instrument meteorological conditions.Dec 2, 1989 · N130ND · Substantial damageNTSB DEN90FA030Accident · 2 fatalField investigationFinal reportBeech F-90 · Lincoln, NMLoss of control due to pilot disorientation while conducting a non precision instrument approach. Contributing to the accident was the pilot's lack of instrument and multiengine experience, and the existing adverse weather.Dec 2, 1989 · N9PU · DestroyedNTSB CHI90LA280Accident · 1 fatalLimited investigationFinal reportPiper PA-22-150 · Engadine, MIA collision with trees and the terrain for undetermined reasons.Dec 2, 1989 · N2440P · Substantial damage