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 LAX91FA386Accident · Serious injuriesField investigationFinal reportCessna 172K · Bullhead City, AZ1) A short circuit, 2) electrical overload which ignited the cabin interior, 3) inadequate electrical circuit protection, and 4) insufficient electrical system design standards.NTSB DEN91LA125Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-180 · Broomfield, COThe pilot's failure to refuel and his misjudged fuel consumption calculations which resulted in fuel exhaustion power loss.NTSB CHI91LA293Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Duluth, MNPremature touchdown while landing by the pic/cfi. Factors related to the accident were low ceilings, rain, and haze; weather evaluation misjudged by the pic/cfi; and visual outlook reduced.NTSB BFO91LA080Accident · No injuriesLimited investigationFinal reportCessna 152 · Croom, MDThe pilot's failure to assure an adequate fuel supply was on board to complete the flight which resulted in fuel exhaustion.NTSB ATL91LA171Accident · No injuriesLimited investigationFinal reportCessna 150L · Pickens, SCThe panicked, intentional interference of the flight controls by the student.NTSB SEA91LA245Accident · No injuriesLimited investigationFinal reportCessna 210 · Arlington, WAThe pilot's failure to extend the landing gear. A factor contributing to the accident was the pilot's failure to utilize the landing checklist.NTSB SEA91LA244Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Metaline Falls, WAThe pilot's inadvertent use of the parking brake. A factor contributing to the accident was the absence of the parking brake on the landing checklist.NTSB SEA91FA229Accident · 2 fatalField investigationFinal reportCessna 150L · Yamhill, ORInadequate inflight planning/decisions. Factors to the accident were: an uncontrolled stall, a tail wind, remedial action was not performed, and poor compensation for wind conditions.NTSB NYC91FA230Accident · 1 fatalField investigationFinal reportBoeing PT-17 · Tranquility, NJLoss of engine power for an undetermined reason, and failure of the pilot to maintain adequate airspeed, while maneuvering to land, which resulted in a stall. The lack of altitude for a recovery from the stall was a related factor.NTSB NYC91DEK01Accident · Serious injuriesFinal reportTimothy Wingate S-7 Courier · Marion, OHThe pilot's failure to maintain adequate separation behind a departing larger aircraft resulted in turbulence encounter & subsequent loss of control.NTSB MIA91LA216Accident · No injuriesLimited investigationFinal reportCessna 182 · Titusville, FLThe pilot in command's improper preflight planning and his failure to ensure that the aircraft contained sufficient fuel for the flight.NTSB MIA91LA215Accident · No injuriesLimited investigationFinal reportBell 47G2A · Immokalee, FLThe improper use of the flight controls by the pilot in command, which resulted in a collision with the ground and a nose over.NTSB LAX91LA385Accident · 1 fatalLimited investigationFinal reportCessna C-310B · San Pedro, CAAn inflight loss of control for undetermined reasons.NTSB CHI91LA292Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly X-7 · Altoona, IAWeather evaluation misjudged and overconfidence in personal ability. A factor related to the accident was high winds.NTSB CHI91LA290Accident · No injuriesLimited investigationFinal reportCessna 152 · Minneapolis, KSThe pilot's failure to assure an adequate fuel supply was on board the airplane which resulted in fuel exhaustion. A factor related to the accident was inaccurate preflight planning.NTSB CHI91LA289Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Kansas City, MOThe pilot's misjudgement of the landing flare and not maintaining directional control during a landing touchdown and roll. A factor was the pilot's lack of total expereince.NTSB CHI91DEP13Accident · Serious injuriesFinal reportMerritt Robertson B1-RD · Menasha, WIInadequate visual look out whih resulted in a wire strike and uncontrolled descent.NTSB ANC91LA144Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Noatak, AKWas the pilot's failure to maintain a proper descent rate. Contributing to the accident was the gust of tailwind.NTSB SEA91FA235Accident · 1 fatalField investigationFinal reportPiper PA32RT-300T · Mayfield, UTPoor in flight planning/decision. Factors to the accident were: flight into known adverse weather, inadvertent VFR flight into IMC and inadequate clearance.NTSB NYC91DNC05Accident · No injuriesFinal reportHomebuilt Avid Flyer · Keene, NHA loss of control due to improper use of the flight controls. Factors related to the accident were the pilot's lack of experience in make and model.NTSB CHI91LA288Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Afton, MNThe pilot's inadvertent lowering of the wheels during the water landing.NTSB NYC91LA229Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Somerville, NJAn off airport landing in unsuitable terrain following a power loss due to oil exhaustion. A factor related to the accident was the operators decision not to follow the recommendations of the Piper cherokee service manual.NTSB LAX91LA383Accident · 3 fatalLimited investigationFinal reportCessna 172 · Arroyo Grande, CAThe pilot's failure to maintain a proper altitude, and continued flight into instrument meteorological conditions.NTSB BFO91LA079Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Fallston, MDThe pilot's failure to accurately determine the fuel quantity before his flight and monitor the quantity during the flight, which resulted in fuel exhaustion due to an inadequate fuel supply.NTSB ANC91LA145Accident · No injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKWas the pilot's failure to maintain airplane control during the takeoff. Contributing to the accident was the downdraft and unfavorable wind.NTSB ANC91LA143Accident · No injuriesLimited investigationFinal reportCessna 180 · Bethel, AKThe pilot's failure to obtain proper airspeed. Contributing to the accident was the pilot's improper compensation for wind conditions and the unfavorable wind.NTSB LAX91LA382Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Redwood City, CAThe fatigue failure of the number two connecting rod and rod cap due to an engine overspeed condition which the rods and rod caps were exposed at some undetermined historical point.NTSB ANC91LA141Accident · No injuriesLimited investigationFinal reportCessna 170-B · Iowa Ridge, AKThe pilot-in-command's failure to identify the rough and uneven, unsuitable terrain. Contributing to the accident was the rough and uneven terrain.NTSB DEN91DTE02Accident · 1 fatalFinal reportCresawn Pitts S1-C · Calhan, COThe pilot's failure to attain adequate aircraft control to avoid terrain collision.NTSB CHI91LA280Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Algonquin, ILIncapacitation of the pilot due to a heart attack.NTSB ATL91LA170Accident · No injuriesLimited investigationFinal reportBeech B-33 · Asheville, NCThe pilot's selection of unsuitable terrain for takeoff. Factors were tall wet grass, and the failure of airport personnel to maintain the runway surface.NTSB ANC91FA142Accident · No injuriesField investigationFinal reportCessna 208 · Dillingham, AKThe pilot's inattentive preflight inspection which resulted in his failure to properly secure the engine oil tube filler cap resulting in the loss of engine oil and oil pressure and the pilot's failure to properly compensate for wind conditions during the…NTSB SEA91LA231Accident · No injuriesLimited investigationFinal reportCessna 310F · Corvallis, ORA disconnected air induction line, and the pilot's inflight decision to execute a 180 degree turn back to the airport. His lack of experience in multi-engine aircraft, his overall lack of familiarity and lack of recent experience in the type aircraft were…NTSB MIA91LA214Accident · Serious injuriesLimited investigationFinal reportRyan Navion A · De Funiak Spgs, FLThe loss of engine power for undetermined reasons which resulted in an inflight collision with a tree and the ground during the subsequent forced landing.NTSB LAX91LA384Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Hayward, CAThe failure of the pilot to maintain directional control of the aircraft while correcting an unwanted deviation.NTSB LAX91LA381Accident · No injuriesLimited investigationFinal reportCessna C-210 · Calexico, CAA non-mechanical loss of engine power due to fuel starvation from the pilot's improper use of the fuel supply.NTSB LAX91LA380Accident · Minor injuriesLimited investigationFinal reportCessna C-340A · Brawley, CAThe pilot's selection of the wrong landing runway and his failure to attain the proper touchdown location. Factors which contributed to the accident were related to the pilot's inadequate observations of the weather and the tailwind condition which existed.NTSB DEN91LA124Accident · No injuriesLimited investigationFinal reportBoeing A 75N1 · Lordsburg, NMUnexpected encounter with adverse wind (downdraft).NTSB DEN91LA123Accident · No injuriesLimited investigationFinal reportCessna A185F · Conchas Dam, NMLanding gear locking mechanism loose, landing gear wheel deployed inadvertently, and maintenance alignment not performed. Factors were: propeller governor underspeed, maintenance adjustment not corrected, and lowering of flaps not performed.NTSB DEN91LA122Accident · No injuriesLimited investigationFinal reportStinson 108 · Steamboat Sprin, COA swerve initiated by the pilot in command to avoid a collision with a deer during takeoff roll.NTSB CHI91LA284Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Pulaski, WIThe pilot's inadequate compensation for wind conditions. The gusty crosswind was a related factor.NTSB CHI91LA282Accident · 1 fatalLimited investigationFinal reportPiper PA-22-150 · Emporia, KSThe pilot's VFR flight into instrument meteorological conditions (IMC), and his delay in taking remedial action. The weather (fog) was a related factor.NTSB ATL91LA169Accident · Minor injuriesLimited investigationFinal reportBates, Frank L Skybolt · Yatesville, GAThe pilot's failure to maintain a proper altitude during maneuvering flight.NTSB ATL91LA168Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235C · Bainbridge, GAThe pilot's failure to maintain adequate clearance from objects while practicing aerial application procedures.NTSB SEA91LA230Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Dixie, IDThe pilot's failure to maintain adequate clearance with tree(s) during the initial climb. Factors contributing to the accident were the high density altitude and downdraft conditions.NTSB SEA91LA227Accident · Serious injuriesLimited investigationFinal reportNorth American Navion A · Chehalis, WATotal loss of engine power on initial takeoff climb due to the fatigue fracture of the number one piston connecting rod resulting in a forced landing and in flight collision with trees.NTSB SEA91LA226Accident · No injuriesLimited investigationFinal reportRyan Navion · Chelan, WAPoor in flight planning/decision by the pilot in command. Factors to the accident were: down drafts, proper alignment was not maintained and inadequate remedial action.NTSB NYC91LA228Accident · No injuriesLimited investigationFinal reportSportavia-Putzer RF5B · Lockport, NYThe failure of the pilot to maintain directional control of the glider during landing. A factor related to the accident was the turbulence encountered on approach.NTSB NYC91LA227Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Galloway, OHImproper supervision by the flight instructor which resulted in an inadvertent ground contact and a dynamic rollover. A factor related to the accident was improper use of the flight controls by the non-rated student pilot.NTSB LAX91LA379Accident · No injuriesLimited investigationFinal reportCessna C-152 · Palo Alto, CAImproper recovery from a bounced landing by the student pilot and the delayed remedial action of the instructor pilot. Contributing to this accident was the student pilot's failure to maintain the proper descent rate which resulted in a bounced landing and…