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 LAX95GA273Accident · No injuriesFinal reportCessna 305A · Hemet, CAthe pilot's decision to execute a wheel landing under crosswind conditions and his failure to adequately compensate for the winds, which led to a loss of directional control and a ground loop.Jul 29, 1995 · N65067 · Substantial damageNTSB LAX95FA272Accident · 2 fatalField investigationFinal reportRockwell 112TC · Los Angeles, CAan undetermined aircraft system malfunction, and the pilot's delayed remedial action in response to insufficient braking action and/or inability to control engine power.Jul 29, 1995 · N4569W · DestroyedNTSB FTW95LA324Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Raton, NMThe pilot's inadvertent activation of the flaps. Factors in the accident were the weather conditions and the dark night.Jul 29, 1995 · N49209 · Substantial damageNTSB FTW95LA323Accident · Serious injuriesLimited investigationFinal reportHead Balloons AX8-88 · Mesquite, TXThe pilot's inadequate weather evaluation and the crewmember's failure to hold onto the basket. A factor was the high wind.Jul 29, 1995 · N4516R · Minor damageNTSB FTW95LA320Accident · No injuriesLimited investigationFinal reportPiper PA-60-601A · Fulshear, TXThe pilot's failure to maintain a proper climb rate after take off. Factors were the pilot's diverted attention toward the malfunctioning landing gear, his intentional shutdown of operational engines, and the lack of suitable terrain for landing.Jul 29, 1995 · N135TS · Substantial damageNTSB CHI95LA251Accident · Minor injuriesLimited investigationFinal reportAviat Pitts S2B · Junction City, KSThe pilot's failure to abort the landing despite excessive speed and insufficient runway length remaining. Contributing factors were the pilot's lack of experience in the make and model aircraft, and the crosswind.Jul 29, 1995 · N1585P · Substantial damageNTSB CHI95LA248Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Niles, MIThe pilot's failure to ensure an adequate supply of fuel was aboard the aircraft during preflight planning and his failure to lean the engine mixture during cruise flight.Jul 29, 1995 · N7295A · Substantial damageNTSB CHI95LA241Accident · No injuriesLimited investigationFinal reportCessna 188 · Bremen, NDthe pilot's inadequate preflight planning. Deteriating aircraft performance was a factor.Jul 29, 1995 · N9980G · DestroyedNTSB ANC95LA121Accident · No injuriesLimited investigationFinal reportCessna 206G · Port Alsworth, AKThe pilot's inadequate compensation for the crosswind condition, which resulted in a failure to maintain runway alignment. The crosswind and proximity of trees were related factors.Jul 29, 1995 · N5371U · Substantial damageNTSB ANC95LA120Accident · No injuriesLimited investigationFinal reportCessna 182 · Kenai, AKFailure of the pilot to remain clear of the duck shack (building) during the takeoff roll. The crosswind and proximity of the building were related factors.Jul 29, 1995 · N2643F · Substantial damageNTSB ANC95LA119Accident · 4 fatalLimited investigationFinal reportCessna 421C · Cordova, AKMechanical loss of engine power for undetermined reason(s), and subsequent in-flight collision with water (or ditching at sea).Jul 29, 1995 · N800DD · DestroyedNTSB SEA95LA188Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Ephrata, WAThe pilot's inadequate compensation for wind conditions. Factors contributing to the accident were crosswinds and gusts.Jul 28, 1995 · N6774Q · Substantial damageNTSB SEA95LA164Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Deer Park, WAA loss of engine power for undetermined reasons. A factor in the accident was the pilot's lack of proficiency in wheel-landings.Jul 28, 1995 · N40191 · Substantial damageNTSB LAX95LA274Accident · No injuriesLimited investigationFinal reportNorth American AT-6F · Long Beach, CAthe failure of the left main landing gear locking mechanism to fully seat in the 'down' position due to loose attachment bolts.Jul 28, 1995 · N3173L · Substantial damageNTSB FTW95LA322Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Edna, TXThe collapsing of the landing gear for undetermined reasons.Jul 28, 1995 · N4182X · Substantial damageNTSB FTW95LA321Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201 · San Antonio, TXThe dual student's delay in aborting the takeoff. A factor was the flight instructor's inadequate supervision.Jul 28, 1995 · N36085 · DestroyedNTSB FTW95LA318Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Muskogee, OKThe pilot's evasive manuever to take off with insufficient runway available for attaining takeoff airspeed. Factors which contributed to the accident were: the unauthorized use of the airplane, the pilot's anxiety, and the dark night.Jul 28, 1995 · N22637 · Substantial damageNTSB FTW95FA319Accident · No injuriesField investigationFinal reportBoeing 737-3A4 · Dallas, TXFailure of the flightcrews of the Boeing 737, N675AA, and the Cessna 401, N31DB, to see and avoid each other. Factors were: the failure of 737 flightcrew to respond to the traffic advisory given by the ground controller identifying potentially conflicting…Jul 28, 1995 · N675AA · 2 aircraft · Minor damageNTSB CHI95TA243Accident · Minor injuriesFinal reportSchweizer 300C · Kansas City, MOground resonance as a result of improper servicing of the main landing gear dampers.Jul 28, 1995 · N643KC · Substantial damageNTSB CHI95LA245Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Oklee, MNthe pilot failed to maintain clearance with trees. Factors associated with the accident were the trees and the pilot's diverted attention.Jul 28, 1995 · N7797Z · DestroyedNTSB CHI95LA244Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164B · Morris, MNthe pilot failed to maintain obstacle clearance.Jul 28, 1995 · N36316 · DestroyedNTSB LAX95LA271Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Redlands, CAThe company's maintenance personnel improper servicing of the landing skid actuators.Jul 27, 1995 · N747MK · Substantial damageNTSB LAX95LA270Accident · No injuriesLimited investigationFinal reportBeech 77 · Madera, CAThe student pilot's improper compensation for the wind condition and improper use of the rudder. The whirlwind was a factor in this accident.Jul 27, 1995 · N38062 · Substantial damageNTSB FTW95LA317Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Mccrory, ARThe loss of engine power due to a cracked cylinder. A factor was the lack of suitable terrain for the forced landing.Jul 27, 1995 · N6636Q · Substantial damageNTSB CHI95LA250Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Park River, NDthe loss of power due to the primary lead in the left magneto being grounded against the case, and the improper clearance of the breaker point gaps. A factor was the lack of suitable terrain on which to perform the forced landing.Jul 27, 1995 · N949X · Substantial damageNTSB CHI95FA242Accident · No injuriesField investigationFinal reportRevolution Helicopter MINI-500 · Oshkosh, WIthe inadequate design of the helicopter skid shoes. Factors related to the accident were: false indications of rotor rpm and EGT which led to seizure of the piston.Jul 27, 1995 · N500ZZ · Substantial damageNTSB SEA95LA163Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Wellsville, UTThe pilot's failure to maintain airspeed. Factors in the accident were the pilot's lack of experience with flying in mountainous terrain and the high density altitude.Jul 26, 1995 · N588BR · Substantial damageNTSB NYC95LA176Accident · 1 fatalLimited investigationFinal reportKenneth Savidge Vari Viggen · Abingdon, VAThe pilot's failure to maintain adequate airspeed, which resulted in a stall. A contributing factor was the pilot's lack of experience in make and model.Jul 26, 1995 · N93VV · DestroyedNTSB LAX95LA269Accident · 1 fatalLimited investigationFinal reportRockwell S-2R · Tulare, CAfailure of the pilot to see and avoid power lines along his route of flight.Jul 26, 1995 · N5035X · DestroyedNTSB CHI95LA247Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Poplar Bluff, MOthe pilot's inadequate preflight/planning preparation. Factors in the accident were: the loss of engine power due to carburetor icing, the wet runway, and the ditch.Jul 26, 1995 · N3655Q · Substantial damageNTSB CHI95LA240Accident · No injuriesLimited investigationFinal reportCessna 550 · Minneapolis, MNfailure of the landing gear braking system for undetermined reason(s) and the pilot's failure to perform the emergency procedure of operating the emergency brake system. Rough/uneven terrain was a related factor.Jul 26, 1995 · N72WC · Substantial damageNTSB ATL95LA148Accident · No injuriesLimited investigationFinal reportPiper PA-12 · N. Myrtle Beach, SCThe improper starting procedure used by the pilot in that he failed to use wheel chocks to preclude aircraft movement. Additionally, the throttle was not placed in the idle position.Jul 26, 1995 · N3036M · Substantial damageNTSB ANC95LA115Accident · Minor injuriesLimited investigationFinal reportBell 206B · Talkeetna, AKThe inadvertent restriction of the anti-torque pedal by the pilot's foot, while the pilot (an incomplete paraplegic) was attempting to land.Jul 26, 1995 · N85CA · Substantial damageNTSB ANC95LA114Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Tyonek, AKThe pilot-in-command's failure to maintain airspeed.Jul 26, 1995 · N8792D · Substantial damageNTSB SEA95LA162Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Cody, WYThe pilot's failure to refuel which resulted in a loss of power due to fuel exhaustion.Jul 25, 1995 · N9492T · Substantial damageNTSB NYC95LA175Accident · Minor injuriesLimited investigationFinal reportVarga TRI-Q200 · Elyria, OHthe pilot's decision to perform a staggered takeoff on the downwind side of the runway, which resulted in a wake turbulence encounter, loss of control in flight, and uncontrolled descent onto the runway. A factor was the pilot's lack of experience in…Jul 25, 1995 · N888TQ · DestroyedNTSB NYC95IA178Incident · No injuriesIncident investigationFinal reportBritish Aerospace RJ-70 · New York, NYthe aileron interconnect became uncoupled, when an abrupt and/or large aileron movement was made in response to a wake turbulence encounter, while on a VOR approach with the autopilot engaged. A factor relating to the incident was: inadequate in-flight…Jul 25, 1995 · N833BE · No damageNTSB MIA95LA190Accident · No injuriesLimited investigationFinal reportMaule MX7-235 · Polk City, FLA fire for an undetermined reason(s).Jul 25, 1995 · N334BL · DestroyedNTSB CHI95LA238Accident · No injuriesLimited investigationFinal reportGrumman AA-1B · Oshkosh, WIthe pilot's failure to maintain clearance.Jul 25, 1995 · N8976L · Substantial damageNTSB ATL95LA143Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Kill Devil Hill, NCThe attempt by the pilots to perform the unfamiliar procedure of starting the airplane's engine by hand.Jul 25, 1995 · N5415J · No damageNTSB SEA95LA161Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Havre, MTthe loss of power due to a failure of the cylinder head exhaust valve rocker box. The tall crop encountered during the forced landing is a factor.Jul 24, 1995 · N3660U · Substantial damageNTSB SEA95LA158Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Idaho Falls, IDThe pilot's inadequate airspeed at liftoff. Contributing to the accident were high density altitude, tailwind conditions, the pilot's selection of an excessive takeoff flap setting, and a windshear encounter.Jul 24, 1995 · N4516K · Substantial damageNTSB NYC95LA174Accident · Minor injuriesLimited investigationFinal reportSocata TB-10 · Damascus, MDThe pilot's inadequate inflight planning and fuel mismanagement, which resulted in fuel exhaustion.Jul 24, 1995 · N20BX · DestroyedNTSB NYC95LA172Accident · No injuriesLimited investigationFinal reportCessna 172P · Teterboro, NJthe student pilot's improper flare which resulted in the airplane porpoising and the subsequent buckling of the firewall.Jul 24, 1995 · N51081 · Substantial damageNTSB MIA95LA189Accident · No injuriesLimited investigationFinal reportFairchild 24W-46 · Callahan, FLLoss of engine power due to failure of the magnetos. A factor in the accident was the lack of suitable terrain for the forced landing.Jul 24, 1995 · N81222 · Substantial damageNTSB LAX95LA268Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Santa Paula, CAfuel exhaustion due to the pilot's failure to perform preflight fuel consumption calculations, and his failure to refuel the aircraft.Jul 24, 1995 · N5388L · Substantial damageNTSB LAX95LA267Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Reno, NVthe pilot's loss of directional control during a crosswind landing using full flaps and the lack of familiarity with the crosswind landing component chart for the aircraft.Jul 24, 1995 · N65923 · Substantial damageNTSB FTW95LA326Accident · No injuriesLimited investigationFinal reportGlasflugel Standard Libelle · Red River, NMThe pilot's lack of compensation for the tailwind and his ensuing failure to attain the proper touchdown point. Factors were the lack of thermal lift and the tailwind.Jul 24, 1995 · N2972 · Substantial damageNTSB FTW95LA316Accident · No injuriesLimited investigationFinal reportGulfstream GV-1 · Englewood, COFailure of the left main landing gear strut attachment for undetermined reasons.Jul 24, 1995 · N480UP · Substantial damageNTSB FTW95LA315Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Silvercliff, COFailure by the pilot to fuel the aircraft which resulted in fuel exhaustion. A factor was unsuitable terrain for a forced landing.Jul 24, 1995 · N9304B · Substantial damage