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 SEA94LA144Accident · No injuriesLimited investigationFinal reportCessna 182P · Salt Lake City, UTAn improper flare by the pilot, who was landing the aircraft, at the time it was damaged.NTSB SEA94LA133Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Lookout Pass, IDPoor in-flight planning. Factors include cloudy weather.NTSB LAX94LA226Accident · 1 fatalLimited investigationFinal reportParker Rotorway Exec 90 · Fallbrook, CAThe pilot's improper preflight and miscalculation of remaining fuel, which resulted in fuel exhaustion, and improper autorotation, due to inadequate transition/upgrade training and lack of familiarity with helicopters.NTSB FTW94LA189Accident · No injuriesLimited investigationFinal reportBeech 35 · Mckinney, TXThe ailerons being locked by a foreign object.NTSB CHI94LA185Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Lake City, MIThe pilot-in-command's inadequate compensation for wind conditions. Factors were the pilot-in-command's not using all available runway, premature lift off, and a crosswind.NTSB CHI94LA179Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Lodi, WIthe pilot's failure to maintain direction control which resulted from a inadequate compensation for the crosswind conditions. Factors related to the accident were the pilot's diverted attention, the crosswind, the trees which were contacted.NTSB ATL94LA109Accident · No injuriesLimited investigationFinal reportPiper PA-22\20 · Kill Devil Hill, NCThe pilot's failure to adequately compensate for the crosswind condition during a landing rollout.NTSB ANC94LA059Accident · No injuriesLimited investigationFinal reportCessna 185F · Fairbanks, AKThe pilot's failure to maintain directional control during takeoff.NTSB SEA94LA143Accident · No injuriesLimited investigationFinal reportWray KR-2 · Puyallup, WAAn improperly functioning fuel boost pump.NTSB SEA94LA135Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-260 · Rexburg, IDEngine failure after loss of oil due to a ruptured oil line.NTSB SEA94LA131Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Touchet, WAThe pilot's inadequate compensation for wind conditions. The wind gusts were a factor.NTSB SEA94FA129Accident · 3 fatalField investigationFinal reportCessna 182B · Rock Springs, WYAn excessive descent rate in the turn from base to final. Factors include a dark night, high winds, and the pilot's fatigue from his flight and ground schedule the day of the accident.NTSB NYC94LA100Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Toronto, OHthe pilot's improper flare, which resulted in the nose gear collapsing and the subsequent nose over of the airplane.NTSB NYC94LA095Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-E · Warrenton, VAthe pilot did not maintain directional control of the airplane during an aborted takeoff, which resulted in the airplane veering off the runway and nosing over. A factor in this accident was the pilot's lack of experience on grass strips in this make and…NTSB LAX94LA225Accident · Serious injuriesLimited investigationFinal reportStaudacher 300S · Chandler, AZThe operation of the engine at an RPM setting that exceeded the original design specifications and resulted in the failure of the no. 5 connecting rod bearing.NTSB FTW94LA184Accident · Minor injuriesLimited investigationFinal reportLockheed P-38 · Breckenridge, TXThe fuel starvation induced loss of power due to improper positioning of the fuel selector. Factors were the pilot's lack of experience in the type airplane, and the lack of suitable terrain for the forced landing.NTSB FTW94FA183Accident · 2 fatalField investigationFinal reportCessna 320E · Battle Mountain, NVThe pilot's failure to maintain terrain clearance while maneuvering during a low level aerial mapping flight. A factor was the box canyon.NTSB CHI94LA192Accident · No injuriesLimited investigationFinal reportClassic YMF-5 · Noblesville, INthe pilot's excessive use of brakes. Factors related to the accident were the crosswind and the pilot's inadequate compensation for the wind conditions.NTSB CHI94LA182Accident · No injuriesLimited investigationFinal reportCessna P-210N · Milwaukee, WIImproper in-flight planning and decision making by the pilot which resulted in fuel exhaustion.NTSB CHI94LA178Accident · 1 fatalLimited investigationFinal reportCessna 150L · Richmond, INInadequate visual lookout by the pilots of both airplanes.NTSB BFO94FA082Accident · No injuriesField investigationFinal reportCessna A150L · Leonardtown, MDImproper use of carburetor heat by the pilot, which resulted in loss of engine power due to carburetor ice. A contributing factor was the presence of carburetor icing conditions.NTSB ATL94LA108Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Williston, TNThe pilot's failure to maintain flying speed which resulted in a stall and a collision with the ground.NTSB ANC94LA061Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Anchorage, AKThe failure of an exhaust valve. The lack of suitable terrain for a forced landing was a factor.NTSB SEA94LA132Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Nashua, MTAirspeed was not maintained. Factors include an inadvertent stall.NTSB SEA94LA128Accident · Serious injuriesLimited investigationFinal reportBell 204B · Libby, MTThe fatigue fracture of the 42 degree gear box input pinion. Factors include unsuitable, mountainous/hilly terrain.NTSB MIA94LA150Accident · No injuriesLimited investigationFinal reportMooney M20-J · Apalachicola, FLThe pilot's inadequate compensation for the crosswind resulting in not maintaining alignment with the runway and the pilot's delay in aborting the landing. The crosswind was a factor.NTSB LAX94LA240Accident · No injuriesLimited investigationFinal reportCessna 150M · Lancaster, CAthe flight instructor's failure to maintain an adequate airspeed margin while maneuvering at minimum controllable airspeed. A factor in the accident was the instructor's selection of an inadequate above ground altitude to begin the maneuver.NTSB CHI94LA180Accident · No injuriesLimited investigationFinal reportMooney M20E · Omaha, NEinaccurate fuel consumption calculations and the inadequate fuel supply for the flight. Factors related to the accident were the ditch and the quantity gage which gave a false indication.NTSB CHI94LA177Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Bolivar, MOthe failure of a pressure fuel line. A factor was the encountering of unsuitable terrain during a forced landing.NTSB SEA94LA159Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-2 · Friday Harbor, WAThe pilot's accidental extension of his hand into the arc of the turning propeller. Factors include high winds during the docking process.NTSB MIA94LA157Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Bunnell, FLThe pilot-in-command's improper use of flight controls (cyclic/collective) resulting in a hard landing.NTSB MIA94LA154Accident · No injuriesLimited investigationFinal reportPitts S2B · Keystone Height, FLThe pilot-in-command's exceeding of the design limitations of the airplane.NTSB FTW94LA181Accident · No injuriesLimited investigationFinal reportMooney M20J · Willcox, AZThe failure of the connecting rod due to lack of lubrication. Factors were the previous damage to the engine, and the unsuitable terrain at the pilot's disposal for the forced landing.NTSB CHI94LA181Accident · No injuriesLimited investigationFinal reportCessna 152 · Olathe, KSthe pilot-in-command (CFI's) improper compensation for wind conditions and his poor in flight decision making. Factors were a tailwind and a vehicle on the runway.NTSB CHI94DTG01Accident · No injuriesFinal reportGrumman G-164-A · La Moure, NDfailure of the pilot to maintain directional control.NTSB ATL94LA107Accident · No injuriesLimited investigationFinal reportCessna 172N · Hartford, ALThe student pilot's inadequate compensation for gusting wind conditions during the approach to land. Factors were the instructor pilot's inadequate supervision of his student, the gusting wind conditions, and the trees located in close proximity to the runway.NTSB NYC94LA094Accident · 1 fatalLimited investigationFinal reportBradford Seahawk · Richmond, KYwas the loss of engine power for undetermined reasons, and the collision with an object during the subsequent forced landing.NTSB LAX94LA224Accident · No injuriesLimited investigationFinal reportCessna 152 · Los Banos, CAthe student pilot's inadequate compensation for the existing crosswind conditions and his resultant loss of directional control. A factor in the accident was the student's lack of total flight experience.NTSB FTW94LA180Accident · 1 fatalLimited investigationFinal reportCessna 182A · Roland, ARBoth the pilot and passenger's failure to follow procedure/directives.NTSB CHI94LA176Accident · No injuriesLimited investigationFinal reportSnow 600-S2C · Bancroft, WIthe pilots failure to select carburetor heat during an extended descent, which resulted in loss of engine power. Factors were carburetor icing conditions and the presence of a ditch at the forced landing site.NTSB CHI94LA175Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Toulon, ILthe improper reassembly of the main rotor blade dampers and the underservicing of the landing gear skid hydraulic struts which resulted in ground resonance of the helicopter when the first takeoff after reassembly was attempted.NTSB CHI94LA174Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Weeping Water, NEthe pilot-in-command's misjudging compensation for wind conditions. Factors were tailwind, and wind information confusing.NTSB ATL94LA106Accident · No injuriesLimited investigationFinal reportCessna A185F · Chapel Hill, NCThe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control during the landing roll. Factors were the crosswinds and gusts prevailing at the airport at the time of the accident.NTSB NYC94LA093Accident · No injuriesLimited investigationFinal reportCessna 172M · Groton, CTthe pilot's inadequate visual lookout during taxi, which resulted in the airplane's wing tip striking ground support equipment.NTSB NYC94LA092Accident · No injuriesLimited investigationFinal reportCessna 172N · Fredericksburg, VAThe pilot's premature lift-off, resulting in an inadvertent stall/mush back onto the runway, and the pilot's failure to maintain directional control during the aborted takeoff, which resulted in the airplane veering off the runway and colliding with a dirt…NTSB FTW94LA178Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Antonito, COThe pilot's improper compensation for wind conditions. A factor was the gusty crosswind and the pilot inadvertently becoming lost.NTSB FTW94LA177Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Casscoe, ARThe inadvertent stall and power loss for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94FA176Accident · 1 fatalField investigationFinal reportPraker Thorp T18C · Phoenix, AZThe pilot's inability to prevent an inadvertent stall and his inability to recover due to a restriction in the movement of the stabilator for undetermined reasons. A factor was the failure of the owner/builder and the pilot to accomplish a control rigging…NTSB CHI94LA173Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Grand Forks, NDthe pilot-in-command's not maintaining directional control.NTSB CHI94LA171Accident · No injuriesLimited investigationFinal reportCessna 172N · Mackinac Island, MIExcessive airspeed and a failure to attain the proper touchdown point on the runway. Factors related to the accident were the wet runway and the fence which was contacted.