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 FTW95LA099Accident · No injuriesLimited investigationFinal reportMBB BO-105S · Cameron 278bThe pilot's failure to remove the tiedoown during the preflight and an inadequate preflight.Jan 23, 1995 · N51948 · Substantial damageNTSB SEA95LA042Accident · No injuriesLimited investigationFinal reportCessna 152 · Seattle, WAThe pilot misjudging the flare. A factor to the accident was the tailwind.Jan 22, 1995 · N6605P · Substantial damageNTSB SEA95LA041Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Auburn, WACarburetor obstruction due to ingestion of part of the induction air ducting. A factor was the lack of suitable terrain for the forced landing.Jan 22, 1995 · N29598 · Substantial damageNTSB MIA95LA061Accident · No injuriesLimited investigationFinal reportGlassair III · Boynton Beach, FLa violent shimmy of the nose gear for undetermined reason(s), which resulted in an on-ground loss of directional control and a subsequent nose over.Jan 22, 1995 · N300FF · Substantial damageNTSB LAX95LA085Accident · No injuriesLimited investigationFinal reportCessna 172M · Mesa, AZStudent pilot's failure to maintain proper alignment, his delayed remedial action, and improper use of the flight controls. The student pilot's lack of experience was a factor in this accident.Jan 22, 1995 · N73141 · Substantial damageNTSB LAX95LA084Accident · No injuriesLimited investigationFinal reportCessna 195 · Phoenix, AZthe failure of the left main strut due to a pre-existing crack.Jan 22, 1995 · N195JB · Substantial damageNTSB FTW95LA098Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Placitas, NMThe pilot operated beyond the climb capability of the helicopter, resulting in inadequate altitude and terrain clearance over mountainous rising terrain. A factor was turbulence.Jan 22, 1995 · N269ME · Substantial damageNTSB CHI95LA072Accident · No injuriesLimited investigationFinal reportStuart/Wagner Mountain Eagle · Halliday, NDThe pilot's premature lift-off and delayed aborted takeoff.Jan 22, 1995 · N2176Z · Substantial damageNTSB SEA95LA040Accident · No injuriesLimited investigationFinal reportCessna A185E · Hillsboro, ORA loss of engine power for undetermined reasons.Jan 21, 1995 · N748 · Substantial damageNTSB SEA95LA039Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · La Grande, ORFailure of the pilot to maintain proper altitude/clearance from higher terrain that was located near the airport. Factors related to the accident were: low ceiling, fog, false/incorrect indication of the NDB, failure of other personnel to properly issue a…Jan 21, 1995 · N36PB · Substantial damageNTSB LAX95LA083Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Lodi, CAthe pilot's inadequate compensation for the existing crosswind wind condition and his failure to maintain proper alignment with the runway.Jan 21, 1995 · N9359K · Substantial damageNTSB CHI95LA077Accident · No injuriesLimited investigationFinal reportCessna 150F · Castlewood, SDthe pilot's inadequate preflight planning and preparation. Factors associated with the accident are the snow covered/drifted runway, and a fence.Jan 21, 1995 · N8981S · Substantial damageNTSB CHI95LA073Accident · No injuriesLimited investigationFinal reportCessna 421C · Angola, INOverload failure of the right main landing gear shock strut sleeve for an unknown reason.Jan 21, 1995 · N421AW · Substantial damageNTSB CHI95FA071Accident · 2 fatalField investigationFinal reportBacon QUESTAIR-VENTURE · Des Moines, IAThe pilot's failure to maintain aircraft control during the emergency descent, resulting in a stall/spin. Factors were material defects in the material used to manufacture the crankshaft, resulting in the crankshaft fracturing after approximately 200 hours in…Jan 21, 1995 · N4QV · DestroyedNTSB MIA95T#A04Accident · No injuriesClass 3Final reportCessna 180 · Camilla, GAJan 20, 1995 · N2985K · Substantial damageNTSB LAX95FA082Accident · Minor injuriesField investigationFinal reportPiper PA-38-112 · Joshua Tree, CAthe operator's inadequate annual inspection by failing to find that the flight control's horizontal section of the 'T' bar was rubbing against the vacuum hoses behind the instrument panel. The jammed 'T' bar and the rough terrain were factors in this accident.Jan 20, 1995 · N4279E · Substantial damageNTSB FTW95LA097Accident · No injuriesLimited investigationFinal reportCessna 150M · Prescott, ARFuel exhaustion due to the pilot's failure to refuel. Factors were the pilot's disorientation and lack of suitable terrain for a forced landing.Jan 20, 1995 · N704CH · Substantial damageNTSB CHI95LA070Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Cottage Grove, WIThe pilot's selection of unsuitable terrain/runway for landing. Factors related to the accident were: the unfavorable wind, icy runway condition, and snowbank at the end of the runway.Jan 20, 1995 · N84603 · DestroyedNTSB ANC95LA029Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Akiak, AKThe partial loss of engine power due to an erratic spark plug.Jan 20, 1995 · N4480X · Substantial damageNTSB SEA95FA038Accident · 3 fatalField investigationFinal reportBeech V35 · Moose, WYThe pilot's failure to fly the proper glidepath. A factor was the dark night light conditions.Jan 19, 1995 · N5603S · Substantial damageNTSB MIA95GA062Accident · 1 fatalFinal reportHughes 369E · Tampa, FLThe pilot's failure to maintain aircraft control as a result of becoming spatially disoriented while maneuvering. Contributing to the accident was the dark night with no visible horizon.Jan 19, 1995 · N4TP · DestroyedNTSB MIA95FA060Accident · 2 fatalField investigationFinal reportPiper PA-28-236 · York, SCThe noninstrument-rated pilot's failure to maintain control of the airplane due to spatial disorientation while conducting flight in instrument meteorological conditions (IMC). A factor relating to the accident was: failure of the pilot to follow…Jan 19, 1995 · N8423B · DestroyedNTSB BFO95T#A01Accident · No injuriesClass 3Final reportRockwell X31 · Edwards Afb, CAJan 19, 1995 · N64584 · DestroyedNTSB ATL95IA043Incident · No injuriesIncident investigationFinal reportBoeing 737-247 · Atlanta, GAThe inadequate inspection of the aircraft by other maintenance personnel, in that they did not properly diagnose discrepancies in the antiskid braking system.Jan 19, 1995 · N4515W · Minor damageNTSB NYC95FA050Accident · 3 fatalField investigationFinal reportAgusta A109C · Jackson Twp, PAThe pilot's improper in-flight planning/decision and failure to maintain control of the airplane after becoming spatially disoriented. Factors related to the accident were: darkness and the adverse weather conditions.Jan 18, 1995 · N1WD · DestroyedNTSB FTW95FA094Accident · Minor injuriesField investigationFinal reportCessna 208B · Lubbock, TXThe pilot's failure to remove ice from the airframe prior to takeoff. Factors were freezing rain the night before and the pilots' incomplete preflight inspection.Jan 18, 1995 · N9461R · DestroyedNTSB ATL95LA042Accident · No injuriesLimited investigationFinal reportMatto KR-2A Modified · Boone, NCThe failure of the propeller retaining bolts for an undetermined reason, which resulted in the separation of the propeller from the engine. The rising, mountainous terrain was a factor.Jan 18, 1995 · N612W · Substantial damageNTSB MIA95WA059Accident · No injuriesForeign investigationCessna 172N · Nevis Island, WNJan 17, 1995 · N738HB · DestroyedNTSB MIA95LA058Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B · Natchez, MSInadequate preflight of the helicopter by the pilot for his failure to separate the dolly before attempting flight.Jan 17, 1995 · N8462E · DestroyedNTSB FTW95IA096Incident · Minor injuriesIncident investigationFinal reportATR 72-212 · Dfw Airport, TXThe uncommanded activation of the brake system on the right main landing gear for undetermined reason.Jan 17, 1995 · N408AT · Minor damageNTSB MIA95WA063Accident · No injuriesForeign investigationSwearingen SA-226-TC · Neuquen, ArgentinaJan 16, 1995 · N622SP · Minor damageNTSB CHI95LA068Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Brookfield, WIThe instructor's failure to maintain clearance with trees. Factors associated with the accident were the trees and the night lighting conditions.Jan 16, 1995 · N39955 · DestroyedNTSB BFO95LA027Accident · Serious injuriesLimited investigationFinal reportCessna 310Q · Clarion, PAThe failure of the right wing de-ice boot during operation in conditions of ice accumulation, which resulted in a loss of aircraft controllability during the approach/landing. The icing condition was a factor.Jan 16, 1995 · N7943Q · DestroyedNTSB ATL95LA041Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Meridianville, ALThe failure of the student pilot to maintain directional control of the aircraft.Jan 16, 1995 · N739RN · Substantial damageNTSB ATL95LA040Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Orange Beach, ALA loss of engine power for undetermined reasons.Jan 16, 1995 · N32411 · Substantial damageNTSB LAX95FA079Accident · 2 fatalField investigationFinal reportBell 206B · Los Angeles, CAThe pilot's continued VFR flight into instrument meteorological conditions. Factors which contributed to the accident were: the pilot's and operator's failure to follow their established dispatch procedures, the pilot's poor judgment in initiating the flight,…Jan 15, 1995 · N2209P · DestroyedNTSB CHI95LA067Accident · No injuriesLimited investigationFinal reportCessna 172N · Kansas City, MOAn improper recovery from a bounced landing. Factors associated with the accident were an improper airspeed and not attaining a proper descent rate by the pilot.Jan 15, 1995 · N75585 · Substantial damageNTSB ANC95LA028Accident · No injuriesLimited investigationFinal reportCessna 172 · Anvik, AKThe pilot's failure to follow the procedure in the pilot's operating handbook concerning the uneven distribution of fuel, and starvation of the fuel intake line by unporting.Jan 15, 1995 · N6867X · Substantial damageNTSB SEA95FA037Accident · 3 fatalField investigationFinal reportCessna 172N · Blyn, WAThe pilot's VFR flight into instrument meteorological conditions. Factors in the accident were the weather conditions and the dark night.Jan 14, 1995 · N1535E · DestroyedNTSB LAX95FA078Accident · 3 fatalField investigationFinal reportCessna 182R · Wrightwood, CAthe pilot's loss of aircraft control and subsequent inadvertent stall/spin following an encounter with a localized mountain wave condition and turbulence while conducting a search mission in close proximity to mountainous terrain.Jan 14, 1995 · N9706E · DestroyedNTSB FTW95LA093Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Roanoke, TXLoss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Jan 14, 1995 · N9734K · Substantial damageNTSB FTW95LA092Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Miami, OKThe pilot's failure to maintain control of the airplane during takeoff due to his attention being diverted. Factors were the passenger's seat belt buckle blocking the gear up latching mechanism, and his lack of familiarity with the airplane.Jan 14, 1995 · N4024N · Substantial damageNTSB FTW95LA091Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Marshall, ARThe pilot's continued flight into adverse deteriorating weather conditions. A factor was the weather and rising terrain.Jan 14, 1995 · N9590W · DestroyedNTSB LAX95LA102Accident · Minor injuriesLimited investigationFinal reportLuscombe 8F · Wickenburg, AZThe pilot-rated passenger's failure to maintain directional control of the airplane during the takeoff ground roll, and the pilot-in-command's inadequate supervision of the pilot-rated passenger, who had sole access to the airplane's brakes.Jan 13, 1995 · N2183B · Substantial damageNTSB LAX95LA081Accident · No injuriesLimited investigationFinal reportRotorway Rotorway · Chandler, AZthe student pilot's improper use of the helicopter's flight controls and the instructor's inadequate supervision of the flight.Jan 13, 1995 · N9876D · Substantial damageNTSB LAX95FA077Accident · 1 fatalField investigationFinal reportCessna 208B · Pleasanton, CAfailure of the pilot-in-command to maintain visual contact with terrain and sufficient altitude for terrain clearance. Factors in the accident were the pilot's decision to initiate a descent 14 miles from the airport, and weather, specifically cloud…Jan 13, 1995 · N754FE · DestroyedNTSB ATL95LA039Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Burlington, NCThe pilot's improper pre-flight inspection, in that he failed to visually confirm the fuel quantity prior to departure.Jan 13, 1995 · N7144Z · Substantial damageNTSB LAX95FA076Accident · 1 fatalField investigationFinal reportCessna 208B · Flagstaff, AZThe pilot's failure to properly configure the aircraft fuel system prior to takeoff, and his failure maintain an adequate terrain clearance altitude while maneuvering to return to the airport. Factors in the accident were the dark night lighting conditions,…Jan 12, 1995 · N746FE · DestroyedNTSB FTW95LA089Accident · No injuriesLimited investigationFinal reportInterstate S-1A · Amarillo, TXAn inflight fire, the reason for which was undetermined.Jan 12, 1995 · N37239 · DestroyedNTSB FTW95GA090Accident · No injuriesFinal reportHughes 269C · Dumont, TXThe loss of engine power due to overstress fractures of the #3 cylinder connecting rod cap bolts. The origin of the fractures could not be determined.Jan 12, 1995 · N796 · Destroyed