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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
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.NTSB 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.NTSB 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.NTSB 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.NTSB CHI92LA253Accident · No injuriesLimited investigationFinal reportLake LA-4 · Pontiac, MIThe instructor pilot's directing a turn to change heading in the flare.NTSB CHI92LA240Accident · No injuriesLimited investigationFinal reportPiper PA-31T1 · Osage Beach, MOFailure to attain the proper touchdown point.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB LAX92T#A16Accident · No injuriesClass 3Final reportBell 204B · Big Sur, CANTSB LAX92LA346Accident · 1 fatalLimited investigationFinal reportSchempp-Hirth Cirrus · Bishop, CAThe pilot's poor inflight decision to fly over mountainous terrain at an inadequate altitude.NTSB 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…NTSB 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.NTSB 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…NTSB 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…NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB FTW92LA206Accident · Serious injuriesLimited investigationFinal reportCessna T-210N · Palestine, TXThe pilot's disregard of the checklist and the resulting inadvertent stall mush during takeoff.NTSB 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.NTSB CHI92DCJ05Accident · No injuriesFinal reportGrumman-Schweizer G-164B · Atkinson, NEA cracked engine cylinder.NTSB 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.NTSB SEA92LA176Accident · No injuriesLimited investigationFinal reportCessna 180K · Wibaux, MTA poorly planned approach.NTSB NYC92LA154Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Keene, NHAn inadvertent stall during flap retraction, following an aborted landing.NTSB 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.NTSB 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.NTSB 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.NTSB FTW92DPG12Accident · No injuriesFinal reportGrumman G-164A · Mc Crory, ARThe pilots failure to maintain directional control.NTSB CHI92LA239Accident · No injuriesLimited investigationFinal reportCessna 182BTW · Plymouth, MIAn inadvertent ground loop.NTSB 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…NTSB 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.NTSB 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.NTSB SEA92LA175Accident · No injuriesLimited investigationFinal reportCessna 172H · Lakeview, ORThe pilot's failure to maintain directional control. Factors include soft terrain.NTSB 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.NTSB 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.NTSB 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.NTSB LAX92LA344Accident · No injuriesLimited investigationFinal reportCessna 320A · Novato, CAThe locked left brake assembly due to the missing brake retaining clips.NTSB 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.NTSB 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.NTSB 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.NTSB FTW92FA205Accident · 2 fatalField investigationFinal reportCameron V-77 · Mesquite, TXThe failure of the pilot to maintain clearance from known obstacles.NTSB CHI92LA233Accident · Minor injuriesLimited investigationFinal reportMBB BO-105 · Madison, SDThe pilot's inadequate visual lookout and inadvertent descent.NTSB 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.NTSB CHI92DER03Accident · No injuriesFinal reportSchneider/Brashear Sorrell SNS-7 · Alexandria, MNThe pilot's failure to maintain directional control during the landing roll.NTSB 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.NTSB 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.