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 CHI92LA197Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Manchester, MIThe pilot's improper inflight planning/decisions, failure to make a precautionary landing when he realized he was too low to reach the airport, and attempting to stretch his glidepath to reach the runway.NTSB BFO92LA086Accident · No injuriesLimited investigationFinal reportCessna 180 · Sanford, METhe pilot's inadequate compensation for wind conditions.NTSB ANC92LA102Accident · No injuriesLimited investigationFinal reportCessna 180 · Naknek, AKThe pilot's failure to maintain directional control. Factors include gusty crosswind conditions.NTSB SEA92LA144Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Wenatchee, WAThe failure of the pilot to maintain directional control during landing, resulting in a ground loop and aircraft impact with terrain. A factor relating to the accident was the gusty wind conditions.NTSB SEA92LA143Accident · Minor injuriesLimited investigationFinal reportBorgaes Avid Flyer "C" · Chiloquin, ORPower loss for undetermined reasons and nose gear separation due to overload. A factor contributing to the accident was: terrain condition - dirt bank.NTSB MIA92WA146Accident · No injuriesForeign investigationPiper PA32R-300 · Andros Island, BahamasNTSB MIA92LA145Accident · 1 fatalLimited investigationFinal reportRaven S-60A · Dover, FLThe pilot in commands choice of landing area near electrical lines and his failure to exit the balloon and seek safety when it was determined the deflating bag was going to make contact with power lines resulting in his receiving electrocution injuries.NTSB LAX92WA284Accident · 3 fatalForeign investigationBeech 58 · Ensenada, MexicoNTSB LAX92LA278Accident · Minor injuriesLimited investigationFinal reportBell 47G5 · Mesa, AZA partial loss of engine power due to unknown reason (s). Factors in this accident were 1) low altitude when the partial loss of power occurred 2) low rotor RPM as a result of the loss of power, and 3) the pilot not being able to take remedial action due to…NTSB DEN92LA071Accident · No injuriesLimited investigationFinal reportCessna 170 · Franktown, COThe pilot misjudged initiation of the go-around following a balked landing. A factor was: high density altitude.NTSB DEN92LA068Accident · No injuriesLimited investigationFinal reportCessna 172P · Broomfield, COFailure by the pilot to maintain directional control.NTSB CHI92LA200Accident · Minor injuriesLimited investigationFinal reportCessna 140A · Grain Valley, MOThe pilot's excessive application of wheel brakes after touchdown.NTSB CHI92LA199Accident · No injuriesLimited investigationFinal reportCessna 172N · Chesterfield, MOThe improper use of the aircraft brake system by the pilot in command.NTSB CHI92LA196Accident · 2 fatalLimited investigationFinal reportLuscombe 8E · Napoleon, NDThe pilot's failure to maintain airspeed above a stall.NTSB CHI92DCD08Accident · Minor injuriesFinal reportJohn Schackel Q2 · Rutland, IAA fatigue failure of the engine crankshaft during cruise flight.NTSB LAX92LA287Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Tucson, AZThe failure of the student to extend the landing gear prior to landing and the failure of the flight instructor to properly supervise the conduct of the flight.NTSB LAX92LA286Accident · No injuriesLimited investigationFinal reportCessna 172G · Tonopah, NVThe failure of the pilot to adequately identify and compensate for the existing tailwind conditions, and, his failure to initiate a go around when he became aware of being high with a fast ground speed.NTSB LAX92LA277Accident · No injuriesLimited investigationFinal reportO'Donnell Lancair 235 · Winnemucca, NVThe failure of the pilot to maintain directional control of the aircraft during the landing roll.NTSB LAX92LA276Accident · No injuriesLimited investigationFinal reportCessna 421B · Hayward, CAThe explosion of fuel vapors in the right wing due to the pilot's overpriming of the right engine during a start attempt and an uncorrected preexisting fuel system leak. A factor in the accident was inadequate maintenance performed on the aircraft.NTSB LAX92LA275Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Olancha, CA1) The tow pilot's intentional premature release of the glider, which had become airborne, when the tow plane failed to achieve sufficient airspeed during its takeoff ground roll, and, 2) the glider having insufficient altitude at the time of release to…NTSB FTW92LA178Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Port Isabel, TXThe loss of power to the right engine due to a fractured crankshaft while the left engine was secured. Factors were the dual students failure to use carburetor heat while performing maneuvers and the unsuitable terrain.NTSB FTW92LA176Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Marietta, OKEngine power loss for undetermined reasons.NTSB FTW92DRG02Accident · No injuriesFinal reportAero Commander Callair A-9B · Harlingen, TXAn inflight fire due to a loose fuel fitting and fuel line due to improper maintenance.NTSB CHI92LA194Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Belmont, WIThe pilot's poor planning/decision making. Related factors are the low ceilings and fog, the dark night, the pilot's inaccurate weather evaluation and diverted attention, and the pilot's failure to maintain clearance from the higher terrain encountered.NTSB CHI92FA195Accident · 1 fatalField investigationFinal reportMooney M20K · Oconto Falls, WIThe pilot's failure to maintain adequate clearance from obstructions during a low pass.NTSB ANC92LA101Accident · Minor injuriesLimited investigationFinal reportMooney Rans S-7 Courier · Big Lake, AKThe pilot's delayed remedial action, and an inadvertent stall. Factors include wind gusts and a wind shear.NTSB FTW92DPG04Accident · Serious injuriesFinal reportAyres S2R-T11 · Jonesboro, ARThe failure of the company maintenance personnal and the pilot to perform adequate inspections and the separation of flight control surfaces. A factor was the corroded rudder assembly.NTSB DEN92LA069Accident · Serious injuriesLimited investigationFinal reportRaven S-60A · Pecos, NMAn encounter with high winds.NTSB CHI92LA206Accident · Serious injuriesLimited investigationFinal reportBoeing 727-200 · Janesville, WIThe captain's delay in issuing instructions to the flight attendants to take their seats, and his poor crew coordination. A factor in the accident was the turbulence in clouds.NTSB CHI92DCD07Accident · Serious injuriesFinal reportBernard W. Resnik ACRO-SPECIAL · Earlham, IAA loss of total engine power when a failed flapper valve in the air box blocked the flow of air through the carburetor throat.NTSB BFO92LA085Accident · No injuriesLimited investigationFinal reportSchweizer 269D · Watkins Glen, NYFuel starvation as a result of improper rigging of the fuel control unit.NTSB BFO92LA084Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Moneta, VAFailure of the student pilot to maintain directional control during the landing, which resulted in an inadvertent ground swerve. Factors related to the accident were: the student's improper recovery from a bounced landing and proximity of the tree.NTSB ATL92LA135Accident · No injuriesLimited investigationFinal reportCessna 182 · Kennesaw, GAThe inadequate preflight planning by the pilot which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor was the soft terrain at the forced landing site.NTSB SEA92LA142Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Paul, IDLoss of engine power for undetermined reasons and aircraft control not possible by the pilot in command. A factor contributing to the accident was: rough/uneven terrain.NTSB LAX92LA274Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Tulare, CAAn inflight hopper compartment fire due to the incompatibility of the chemical loads, and, the failure of the operator follow the cautionary directives of the chemical manufacturer.NTSB LAX92LA273Accident · No injuriesLimited investigationFinal reportCessna U206E · Mayer, AZThe failure of the engine due to the slippage of the number 2 main bearing and the resultant oil starvation failure of the number 2 connecting rod. The number 2 main bearing slippage was caused by the failure of the pilot/owner to overhaul the engine in a…NTSB CHI92DCQ05Accident · Serious injuriesFinal reportVirgil Larson Varieze,LONG EZ · Chanute, KSA delamination and inflight separation of a propeller blade during cruise flight.NTSB BFO92LA083Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Greenville, VAThe fatigue failure of the fuel injector fuel line resulting in engine failure. Contributing to the accident was the unsuitable terrain in which the forced landing was made.NTSB ANC92LA099Accident · No injuriesLimited investigationFinal reportCessna 185F · Ekuk, AKThe pilot's selection of unsuitable terrain for landing. A factor was the hidden obstruction on the surface of the landing area.NTSB NYC92LA136Accident · 1 fatalLimited investigationFinal reportBeech N35 · Middletown, NYImproper altitude control by the pilot which resulted in a collision with trees.NTSB MIA92LA144Accident · 1 fatalLimited investigationFinal reportDofka, Martin F. KR-2 · Homestead, FLInadvertent stall by the pilot while attempting to return to the airport following loss of engine power. Contributing to the accident was the loss of power due to a sticking exhaust valve, and failure of the pilot to assure all ignition leads were connected…NTSB LAX92LA272Accident · Minor injuriesLimited investigationFinal reportErcoupe 415C · Santa Clarita, CAFuel starvation caused by the inflight separation of the fuel gascolator bowl due to improper component installation.NTSB LAX92LA269Accident · No injuriesLimited investigationFinal reportCessna 180 · Glendale, AZThe failure of the left main gear inner tube due to dry rot, and, the inadequate maintenance and preflight inspections conducted on the aircraft.NTSB LAX92LA268Accident · No injuriesLimited investigationFinal reportCessna 172 · Lake Havasu, AZThe failure of the pilot to adequately compensate for the existing wind conditions and to maintain directional control of the aircraft.NTSB LAX92FA271Accident · 2 fatalField investigationFinal reportHolmes-Salley/Starduster Too SA300 · Chatsworth, CAThe pilots inflight loss of control for undetermined reasons and an inadvertent entry into a stall spin. Contributing to the accident was the pilot's lack of total experience in type of aircraft and a low cloud cover.NTSB FTW92LA174Accident · Minor injuriesLimited investigationFinal reportChampion 7FC · Paris, TXFuel exhaustion power loss. Factors were a loose fuel cap, inadequate preflight by the pilot and the lack of suitable terrain.NTSB FTW92LA172Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Wichita Falls, TXThe pilot's failure to maintain directional control.NTSB FTW92LA171Accident · No injuriesLimited investigationFinal reportCessna R172K · Eufaula, OKThe pilot's inadequate compensation for the wind conditions. The turbulent winds near the end of the runway were a factor in the accident.NTSB DEN92LA065Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300 · Leadville, COThe pilot's failure to compensate for wind conditions and maintain directional control. Factors included: the pilot allowing the airplane to lift off prematurely, and gusty crosswinds.NTSB SEA92LA141Accident · No injuriesLimited investigationFinal reportBell-World 47D1 · Wenatchee, WACarburetor ice and the pilot in command's not being able to maintain clearance. Factors contributing to the accident were: carburetor icing conditions and tree(s).