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 CHI95LA084Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Kenosha, WIthe student's failure to maintain directional control during the landing roll.Feb 6, 1995 · N9025E · Substantial damageNTSB MIA95LA069Accident · No injuriesLimited investigationFinal reportAerofab Lake LA-250 · St. Augustine, FLThe improper adjustment of the turbocharger inlet pipe securing clamp by unknown maintenance personnel.Feb 5, 1995 · N14032 · Substantial damageNTSB LAX95LA134Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Long Beach, CAFailure of the right main tire, and subsequent failure of the pilot to maintain directional control of the airplane. A factor related to the accident was: the pilot's lack of recent flight experience.Feb 5, 1995 · N53866 · Substantial damageNTSB FTW95LA109Accident · Minor injuriesLimited investigationFinal reportRockwell 112B · Coyote, NMWater contamination of the fuel from an unknown source. A factor related to the accident was: lack of suitable terrain for a forced landing.Feb 5, 1995 · N1403J · DestroyedNTSB FTW95LA107Accident · No injuriesLimited investigationFinal reportCessna 150F · Commerce, OKFuel exhaustion as a result of the pilot failing to perform an adequate preflight inspection of the airplane. The lack of suitable terrain on which to make a forced landing was a factor.Feb 5, 1995 · N8732S · Substantial damageNTSB CHI95LA110Accident · No injuriesLimited investigationFinal reportCessna 172 · Nevis, MNthe loss of engine power due to a blockage caused by ice. A factor in the accident was the snow.Feb 5, 1995 · N739FZ · Substantial damageNTSB CHI95LA083Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Lafayette, INthe pilot's failure to perform a go-around. The gusty crosswind was a factor in the accident.Feb 5, 1995 · N38394 · Substantial damageNTSB CHI95FA082Accident · 1 fatalField investigationFinal reportCessna 310L · Valparaiso, INspatial disorientation of the pilot while descending into the clouds. Factors were the moderate turbulance and snow.Feb 5, 1995 · N157JW · DestroyedNTSB SEA95LA046Accident · No injuriesLimited investigationFinal reportCessna 177 · Corvallis, ORThe pilot's improper flare and improper recovery from a bounced landing.Feb 4, 1995 · N2901X · Substantial damageNTSB LAX95LA099Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Rosamond, CAFailure of the pilot to maintain directional control. Soft terrain beside the runway was a related factor.Feb 4, 1995 · N9905T · Substantial damageNTSB LAX95LA098Accident · Serious injuriesLimited investigationFinal reportSchweizer 269C · Red Bluff, CAthe flight instructor's poor in-flight decision to continue flight into a reduced visibility area, his failure to execute a 180-degree turn in a timely manner, and his failure to maintain clearance from the terrain.Feb 4, 1995 · N7509H · Substantial damageNTSB FTW95FA106Accident · 1 fatalField investigationFinal reportCessna 150 · Arnaudville, LAThe pilot's failure to maintain adequate airspeed while circling at low altitude, which resulted in an inadvertent stall and subsequent collision with terrain (wooded river bank). A factor relating to the accident was: the pilot's use of a drug that was not…Feb 4, 1995 · N6464T · DestroyedNTSB CHI95LA081Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · St. Louis, MOA loss of engine power due to an excessive fuel mixture caused by undetermined reasons.Feb 4, 1995 · N694SK · DestroyedNTSB LAX95LA097Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · San Martin, CAthe failure of the pilot to attain takeoff speed and maintain directional control from a grass airstrip and his improper preflight of the runway for obstructions.Feb 3, 1995 · N8643V · Substantial damageNTSB LAX95LA096Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Chowchilla, CAthe in-flight failure and separation of the main rotor hub due to a fatigue crack.Feb 3, 1995 · N9293Z · DestroyedNTSB LAX95LA095Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Carson City, NVthe pilot's improper use of the brakes.Feb 3, 1995 · N12207 · Substantial damageNTSB LAX95LA094Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Sedona, AZthe pilot's improper compensation for the prevailing wind conditions, and his improper remedial action by raising the flaps before applying the power. The downdraft was a factor.Feb 3, 1995 · N46874 · Substantial damageNTSB CHI95LA080Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Brule, NELoss of engine power due to undetermined reasons.Feb 3, 1995 · N3633Q · Substantial damageNTSB MIA95FA070Accident · 2 fatalField investigationFinal reportCessna 172N · Mintonville, KYThe flightcrew's intentional VFR flight into known instrument meteorological conditions. A factor was the inadequate altitude to prevent an inadvertent collision with an obstruction.Feb 2, 1995 · N734KV · DestroyedNTSB LAX95LA093Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Big Bear City, CAThe pilot's improper recovery FR0M a bounced landing, and his failure to attain adequate airspeed in unfavorable wind conditions for an attempted go-around (aborted landing), which resulted in a stall/mush and a dragged wingtip. Factors related to the…Feb 2, 1995 · N83981 · Substantial damageNTSB LAX95LA092Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Buckeye, AZa loss of engine power for undetermined reasons.Feb 1, 1995 · N8950N · Substantial damageNTSB LAX95LA091Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Pixley, CAthe total failure of the number three cylinder. The wet and soft terrain were factors in this accident.Feb 1, 1995 · N705Y · Substantial damageNTSB FTW95LA105Accident · Minor injuriesLimited investigationFinal reportBell 47G-4A · El Indio, TXThe loss of tail rotor effectiveness. A factor was the gusty right quartering tailwind.Feb 1, 1995 · N6SR · DestroyedNTSB DCA95RA017Accident · No injuriesForeign investigationBoeing 737-200 · San Paulo, BrazilFeb 1, 1995 · PPSMVNTSB ATL95LA047Accident · 2 fatalLimited investigationFinal reportBrandt Rutan Longeze · Marietta, GAThe pilot's delayed abort of the ground run which resulted in a runway overrun and collision with the ravine.Feb 1, 1995 · N103JB · DestroyedNTSB ANC95LA030Accident · No injuriesLimited investigationFinal reportCessna 185F · W.Point Village, AKA failure of the pilot to maintain directional control of the airplane. The pilot's excessive remedial reaction and lack of total experience in the accident aircraft make and model were factors in the accident.Feb 1, 1995 · N1095F · Substantial damageNTSB LAX95LA090Accident · No injuriesLimited investigationFinal reportBeech F33A · Tucson, AZthe student pilot's poor short field takeoff procedure and excessive nose rotation resulted in an inadvertent stall. A factor is the student pilot's lack of total experience.Jan 31, 1995 · N6635C · Substantial damageNTSB FTW95LA104Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Mountain View, ARThe pilot's selection of a downwind runway for takeoff, his failure to use all available runway, and delay in aborting the takeoff. A factor was the tailwind.Jan 31, 1995 · N2610L · Substantial damageNTSB MIA95WA068Accident · No injuriesForeign investigationBell 206B3 · Neacon, NicaraguaJan 29, 1995 · N59556 · Substantial damageNTSB MIA95WA067Incident · No injuriesForeign investigationDouglas DC8-62 · Manaus, BrazilJan 29, 1995 · N791AL · Minor damageNTSB CHI95LA078Accident · No injuriesLimited investigationFinal reportBoeing 747-238B · Belleville, MIthe failure of company maintenance personnel to adequately secure the cargo pallets, and the failure of the flightcrew to detect the deficiency during their preflight inspection.Jan 29, 1995 · N706CK · Substantial damageNTSB CHI95LA076Accident · No injuriesLimited investigationFinal reportBeech V35A-TC · Pembina, NDthe pilot's misjudgement of the actual altitude of the airplane. Factors were the visual illusion caused by the snow covered runway environment and the whiteout weather condition.Jan 29, 1995 · N68DC · Substantial damageNTSB ATL95FA046Accident · 1 fatalField investigationFinal reportBeech A36 · Chamblee, GAThe pilot's failure to maintain aircraft control after becoming spatially disoriented. Factors relating to the accident were: the pilot's lack of proficiency (recent experience) in instrument flying, and improper approach control service by vectoring the…Jan 29, 1995 · N3086T · DestroyedNTSB MIA95LA066Accident · No injuriesLimited investigationFinal reportBeech 35 · Sardis, MSA loss of engine power due to fuel starvation caused by a fuel selector stem failure, due to wear, that precluded the pilot from selecting a fuel tank that had fuel.Jan 28, 1995 · N5116C · Substantial damageNTSB MIA95LA065Accident · No injuriesLimited investigationFinal reportBell 206-B3 · Miami, FLInadequate maintenance and inspection, and a loose fuel pc line. The wires were a factor which necessitated early collective pitch.Jan 28, 1995 · N5008N · Substantial damageNTSB MIA95LA064Accident · No injuriesLimited investigationFinal reportBeebe, Dale G. RV-6 · Zellwood, FLThe improper in-flight decision by the pilot to abort takeoff with insufficient runway remaining.Jan 28, 1995 · N109DB · Substantial damageNTSB LAX95FA088Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Big Bear City, CAthe pilot's improper preflight inspection during which he failed to insure removal of the induction air system inlet covers. This action resulted in a partial loss of engine power during initial climb. A factor which contributed to the accident was the…Jan 28, 1995 · N9602J · DestroyedNTSB SEA95LA044Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Salem, ORFuel starvation due to inadequate supervision of the dual student by the pilot-in-command when the dual student improperly adjusted the fuel selector position.Jan 27, 1995 · N9201P · Substantial damageNTSB SEA95FA043Accident · 1 fatalField investigationFinal reportBeech E18S · Butte, MTThe pilot's failure to follow the IFR procedure by not maintaining the proper altitude prior to the initial appraoch fix. Factors to the accident were dark night conditions and a low ceiling.Jan 27, 1995 · N250RP · Substantial damageNTSB FTW95LA103Accident · Serious injuriesLimited investigationFinal reportBoeing 737-2H4 · Dallas, TXThe flight attendants' lack of supervision of deplaning passengers. A factor was lack of supervision by accident victims mother.Jan 27, 1995 · N71SW · No damageNTSB FTW95FA102Accident · 2 fatalField investigationFinal reportCessna 150L · Needville, TXLoss of control at an altitude insufficient for recovery after one of the two pilots on board attempted an aerobatic maneuver.Jan 27, 1995 · N1493Q · DestroyedNTSB CHI95IA079Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE-146-300 · Madison, WIA fuel leak in the no. 2 engine left fuel manifold segment due to a design defect which led to a fatigue crack.Jan 27, 1995 · N611AW · No damageNTSB FTW95FA101Accident · 1 fatalField investigationFinal reportBeech A36 · Wallisville, TXFuel starvation due to improper positioning of the fuel tank selector, which resulted in loss of engine power. Factors related to the accident were: darkness and a lack of suitable terrain for the forced landing.Jan 26, 1995 · N7250U · Substantial damageNTSB FTW95LA095Accident · No injuriesLimited investigationFinal reportBeech 33-A · Lago Vista, TXThe pilot's failure to execute a missed approach at minimums for the non-precision approach and an excessive rate of descent during the circle to land maneuver.Jan 25, 1995 · N55VS · Substantial damageNTSB ATL95LA045Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-300 · Burnsville, NCThe pilot's failure to complete the before-landing checklist to ensure that the landing gear was extended.Jan 25, 1995 · N1999H · Substantial damageNTSB LAX95IA086Incident · No injuriesIncident investigationFinal reportBoeing 737-300 · Albuquerque, NMmaintenance personnel inadvertently overservicing the left main landing gear strut with nitrogen that, during rotation with the aircraft weight on the strut reduced, gave the pilots a rolling sensation to the right.Jan 24, 1995 · N155AW · No damageNTSB FTW95LA100Accident · 1 fatalLimited investigationFinal reportCessna A152 · Houston, TXThe pilot's inadequate supervision of the passenger. A factor was the pilot's inadequate preflight of the aircraft.Jan 24, 1995 · N4892A · Minor damageNTSB CHI95LA075Accident · No injuriesLimited investigationFinal reportBeech C45H · New Hudson, MIThe owner/pilot's inadequate maintenance practices which resulted in a loss of engine power shortly after takeoff and the pilot's inadequate emergency procedure after the power loss occurred. Related factors are trees, diminished airspeed and abrupt touchdown.Jan 24, 1995 · N618K · Substantial damageNTSB CHI95LA074Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Burwell, NEThe pilot's selection of unsuitable terrain for landing and takeoff. A factor was rough/uneven terrain.Jan 24, 1995 · N8825Z · Substantial damageNTSB LAX95LA087Accident · 1 fatalLimited investigationFinal reportStevens S-8 · Tucson, AZThe pilot's failure to maintain adequate control of the airplane to avoid a collision with the ground.Jan 23, 1995 · N66191 · Destroyed