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 NYC92LA160Accident · 1 fatalLimited investigationFinal reportPiper PA-25 · Wallington, OHPilot incapacitation due to acute coronary insufficiency which resulted in a loss of control of the airplane and impact with the ground.Aug 13, 1992 · N4654Y · DestroyedNTSB NYC92LA158Accident · No injuriesLimited investigationFinal reportStinson ST-75 · Sussex, NJThe pilot failed to maintain control of the airplane during the landing roll, and inadvertently swerved and ground looped into two parked airplanes. A factor in this accident was the pilot's lack of expereince in this make and model airplane.Aug 13, 1992 · N8495K · Substantial damageNTSB NYC92FA161Accident · 3 fatalField investigationFinal reportPiper PA-28R-180 · Bradford, NYA mechanical malfunction of the artificial horizon in IMC that resulted in spatial disorientation of the pilot and his inability to maintain airplane orientation. A factor in the accident was the improper maintenance of the artificial horizon.Aug 13, 1992 · N44AE · DestroyedNTSB LAX92LA348Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Laveen, AZThe pilot's failure to maintain altitude during the low-level aerial application procedure turn. Contributing to this accident was the night condition and the high tension wires.Aug 13, 1992 · N4410S · DestroyedNTSB CHI92LA253Accident · No injuriesLimited investigationFinal reportLake LA-4 · Pontiac, MIThe instructor pilot's directing a turn to change heading in the flare.Aug 13, 1992 · N8WW · Substantial damageNTSB CHI92LA240Accident · No injuriesLimited investigationFinal reportPiper PA-31T1 · Osage Beach, MOFailure to attain the proper touchdown point.Aug 13, 1992 · N701PT · Substantial damageNTSB ANC92LA131Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A · Eisenmenger Crk, AKThe pilot's improper preflight planning/preparation, and his failure to attain clearance of the high vegetation during takeoff. A contributing factor to the accident was the high vegetation.Aug 13, 1992 · N3889P · Substantial damageNTSB SEA92LA178Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Pacific City, ORThe pilot selected the wrong runway relative to the wind and then delayed in aborting the landing. The tailwind was a factor.Aug 12, 1992 · N2328Q · Substantial damageNTSB NYC92LA163Accident · No injuriesLimited investigationFinal reportPiper J-3 · Portsmouth, OHThe failure of the propeller leading edge as the result of corrosion and the subsequent forced landing on unsuitable terrain.Aug 12, 1992 · N87945 · Substantial damageNTSB NYC92LA162Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Ocean City, NJThe airplane nosing over on landing roll due to inadequate airplane handling characteristics while landing with the banner attached. Factors related to the accident were the use of rope instead of steel cable, the main landing gear mounted tow hitch, and the…Aug 12, 1992 · N9374D · Substantial damageNTSB NYC92LA159Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · West Mifflin, PAA yaw for unknown reason(s) which resulted in the tail rotor contacting the dirt bank and a loss of control. A factor related to the accident was the decision of the pilot to operate in close vicinity to the dirk bank.Aug 12, 1992 · N2070P · Substantial damageNTSB MIA92LA162Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Randleman, NCThe failure of the pilot-in-command to switch the fuel selector to a tank with fuel, after the engine failed due to fuel starvation.Aug 12, 1992 · N3544W · Substantial damageNTSB LAX92T#A16Accident · No injuriesClass 3Final reportBell 204B · Big Sur, CAAug 12, 1992 · N204CR · Substantial damageNTSB LAX92LA346Accident · 1 fatalLimited investigationFinal reportSchempp-Hirth Cirrus · Bishop, CAThe pilot's poor inflight decision to fly over mountainous terrain at an inadequate altitude.Aug 12, 1992 · N7988 · DestroyedNTSB LAX92GA347Accident · 1 fatalFinal reportHughes 369D · Maxwell, CAThe failure of the pilot to maintain an adequate visual outlook, and failure of the company to provide adequate training. Contributing to the accident was: inadequate company supervision during the operation, and inadequate surveillance by the FAA which…Aug 12, 1992 · N58425 · DestroyedNTSB FTW92DPG14Accident · No injuriesFinal reportAir Tractor AT-300 · Wilmont, ARPower loss due to a failed cracked cylinder. A factor was the lack of suitable terrain for the forced landing.Aug 12, 1992 · N4420S · Substantial damageNTSB ATL92LA159Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Guntersville, ALThe pilot's inadequate evaluation of the in flight weather conditions, and his subsequent loss of aircraft control, which resulted in the design stress limits of the aircraft being exceeded. Factors were clouds, the associated turbulence, and the hail in the…Aug 12, 1992 · N416HC · Substantial damageNTSB ATL92LA158Accident · No injuriesLimited investigationFinal reportCessna 182Q · Ft. Payne, ALThe pilot's improper procedure, in that he failed to raise the flaps following the short field landing, as prescribed in the pilot's information manual, which resulted in a loss of directional control. Factors were the tall grass adjacent to the runway, the…Aug 12, 1992 · N4852N · Substantial damageNTSB ANC92LA130Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Black River, AKThe pilot's improper in flight planning/decision, and his failure to maintain a proper altitude to clear the terrain. Contributing to the accident were the pilot's lack of familiarity with the geographic area, and his lack of total experience in the type…Aug 12, 1992 · N6288S · Substantial damageNTSB ANC92LA128Accident · Minor injuriesLimited investigationFinal reportDe Havilland DHC-2 · Crescent Lake, AKThe pilot's misjudging his altitude on final approach. Contributing to the accident was the glassy water condition.Aug 12, 1992 · N8190Y · Substantial damageNTSB NYC92LA157Accident · No injuriesLimited investigationFinal reportBoeing 747-238 · Newark, NJThe airport authority's failure to assure adequate obstacle clearance for aircraft manuevering around the ramp area.Aug 11, 1992 · GVOIG · Substantial damageNTSB NYC92LA156Accident · No injuriesLimited investigationFinal reportCessna 152 · Plainville, CTFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. The embankment beside the runway was a related factor.Aug 11, 1992 · N69230 · Substantial damageNTSB FTW92LA206Accident · Serious injuriesLimited investigationFinal reportCessna T-210N · Palestine, TXThe pilot's disregard of the checklist and the resulting inadvertent stall mush during takeoff.Aug 11, 1992 · N79MM · DestroyedNTSB CHI92LA238Accident · No injuriesLimited investigationFinal reportBeech A36 · Ann Arbor, MIFuel starvation for undetermined reasons. Factors related to the accident were in blown fuse which rendered the boost pump inoperative and the rough terrain in which the emergency landing was made.Aug 11, 1992 · N377RB · Substantial damageNTSB CHI92DCJ05Accident · No injuriesFinal reportGrumman-Schweizer G-164B · Atkinson, NEA cracked engine cylinder.Aug 11, 1992 · N48672 · Substantial damageNTSB ATL92LA157Accident · No injuriesLimited investigationFinal reportBeech 23-B24R · Walterboro, SCThe inadequate preflight planning by the pilot in command. Factors were the soft runway, and the high density altitude which existed at the time of the attempted departure.Aug 11, 1992 · N6540R · Substantial damageNTSB SEA92LA176Accident · No injuriesLimited investigationFinal reportCessna 180K · Wibaux, MTA poorly planned approach.Aug 10, 1992 · N63242 · Substantial damageNTSB NYC92LA154Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Keene, NHAn inadvertent stall during flap retraction, following an aborted landing.Aug 10, 1992 · N738FW · Substantial damageNTSB MIA92LA163Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Brooksville, FLThe pilot-in-command's failure to maintain alignment with the runway during landing. This resulted in an in-flight collision with a runway marker, collapse of the right main landing gear, and subsequent collision with terrain.Aug 10, 1992 · N119Q · Substantial damageNTSB LAX92LA345Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13H · Merced, CAThe pilot's poor preflight planning/preparation and fuel consumption calculations. Contributing to this accident was fuel exhaustion and the cultivated soft field.Aug 10, 1992 · N51858 · Substantial damageNTSB LAX92LA343Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob 103 · Truckee, CAThe inadequate aircraft maintenance and flight manuals and unavailable information pertaining to the inspection of the spoiler system. Contributing to this accident was the worn and jammed spoiler attachment limiting block.Aug 10, 1992 · N103FB · Substantial damageNTSB FTW92DPG12Accident · No injuriesFinal reportGrumman G-164A · Mc Crory, ARThe pilots failure to maintain directional control.Aug 10, 1992 · N6636Q · Substantial damageNTSB CHI92LA239Accident · No injuriesLimited investigationFinal reportCessna 182BTW · Plymouth, MIAn inadvertent ground loop.Aug 10, 1992 · N2387G · Substantial damageNTSB ATL92LA156Accident · Serious injuriesLimited investigationFinal reportCessna 441 · Gainesville, GAThe poor inflight decision by the pilot in command in that after a partial loss of power, he shut down the wrong engine, did not follow the emergency checklist, did not raise the flaps, and did not retract the landing gear. A factor in the accident was the…Aug 10, 1992 · N920C · Substantial damageNTSB ANC92LA136Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Bettles, AKThe pilot's improper in flight planning/decision, and his failure to maintain a proper altitude while operating in the mountains. A contributing factor was the mountainous terrain.Aug 10, 1992 · N6592L · Substantial damageNTSB ANC92LA125Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Iliamna, AKThe pilot's failure to abort the takeoff. Contributing to the accident was the rough/uneven terrain.Aug 10, 1992 · N7394W · Substantial damageNTSB SEA92LA175Accident · No injuriesLimited investigationFinal reportCessna 172H · Lakeview, ORThe pilot's failure to maintain directional control. Factors include soft terrain.Aug 9, 1992 · N8100L · Substantial damageNTSB NYC92LA155Accident · No injuriesLimited investigationFinal reportBroussard MH-1521M · Elyria, OHThe pilot's improper flare resulting in a hard bounced landing and subsequent blown tire and loss of airplane control.Aug 9, 1992 · N239HL · Substantial damageNTSB NYC92LA152Accident · Minor injuriesLimited investigationFinal reportCessna 210J · Groton, CTA forced landing in unsuitable terrain as a result of a complete loss of engine power for unknown reasons.Aug 9, 1992 · N6172F · DestroyedNTSB NYC92LA151Accident · Minor injuriesLimited investigationFinal reportRockwell 112-TC · St Mary'S, WVThe fatigue cracking fracture of the propeller hub, resulting in a forced landing, and collision with a house.Aug 9, 1992 · N4531W · DestroyedNTSB LAX92LA344Accident · No injuriesLimited investigationFinal reportCessna 320A · Novato, CAThe locked left brake assembly due to the missing brake retaining clips.Aug 9, 1992 · N3014R · Substantial damageNTSB LAX92LA341Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Sedona, AZThe failure of the fixed base operator to properly conduct an annual inspection and inadequate compliance with the airworthiness directive. Contributing to this accident was the total failure of the main landing gear trunion due to fatigue.Aug 9, 1992 · N6649V · Substantial damageNTSB LAX92LA340Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Tolleson, AZThe pilot's selection of unsuitable terrain for takeoff. Contributing to this accident was the ravine that crossed the runway.Aug 9, 1992 · N6809K · Substantial damageNTSB LAX92LA338Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Parker, AZThe inadequate overhaul of the propeller blade by the overhaul facility. Contributing to this accident was the rough and uneven terrain.Aug 9, 1992 · N1547P · Substantial damageNTSB FTW92FA205Accident · 2 fatalField investigationFinal reportCameron V-77 · Mesquite, TXThe failure of the pilot to maintain clearance from known obstacles.Aug 9, 1992 · N9544G · DestroyedNTSB CHI92LA233Accident · Minor injuriesLimited investigationFinal reportMBB BO-105 · Madison, SDThe pilot's inadequate visual lookout and inadvertent descent.Aug 9, 1992 · N30SV · Substantial damageNTSB CHI92FA232Accident · 2 fatalField investigationFinal reportBell 206B · St. Charles, MOThe pilot-in-command's failure to see and avoid the wires, and his physical impairment due to alcohol consumption. A factor which contributed to the effect of the alcohol impairment was the medicine.Aug 9, 1992 · N200LT · DestroyedNTSB CHI92DER03Accident · No injuriesFinal reportSchneider/Brashear Sorrell SNS-7 · Alexandria, MNThe pilot's failure to maintain directional control during the landing roll.Aug 9, 1992 · N226HB · Substantial damageNTSB ATL92LA155Accident · No injuriesLimited investigationFinal reportCessna 150L · Manteo, NCThe delayed level off by the pilot, during the banner pick-up, which resulted in the entanglement of the banner with the horizontal stabilizer.Aug 9, 1992 · N11912 · Substantial damageNTSB ATL92LA154Accident · Minor injuriesLimited investigationFinal reportWeatherly 620A · Cobb, GAThe corroded, and separated, magnetic chip detector plug which allowed the loss of all engine oil and the engine's subsequent seizure. Factors were the inadequate 100 hour inspection, and the high vegetation in the forced landing field.Aug 9, 1992 · N4650W · Substantial damage