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 MIA95LA193Accident · No injuriesLimited investigationFinal reportCessna 150L · Picayune, MSLoss of engine power due to undetermined reasons.NTSB MIA95LA192Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Quitman, MSImproper (low) outflow from the fuel control unit, due to improper maintenance, which resulted in a loss of engine power and a forced landing.NTSB MIA95IA194Incident · No injuriesIncident investigationFinal reportBoeing 737-3B7 · Charlotte, NCImproper installation of the 'a' system flight control computer by company maintenance personnel, which resulted in pin connector(s) being pushed loose and subsequent malfunction of the autopilot.NTSB FTW95LA331Accident · No injuriesLimited investigationFinal reportGrumman G-164A · St.Francisville, LAThe pilot's failure to maintain clearance with the obstruction on short final. A factor was the low visibility.NTSB FTW95LA329Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Englewood, COThe pilot's improper compensation for the 6 knot crosswind. Factors were the pilot's delay in initiating an aborted landing and his lack of total experience.NTSB CHI95LA271Accident · Serious injuriesLimited investigationFinal reportBoeing 757 · Detroit, MIthe flight's encounter with turbulence.NTSB CHI95LA261Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Mecosta, MIthe student's failure to maintain adequate airspeed, and the pilot-in-command's (CFI) inadequate remedial action.NTSB CHI95LA260Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164A-450 · Grand Forks, NDthe pilot's failure to maintain clearance with transmission wires. A factor in the accident was the sunglare.NTSB BFO95LA076Accident · No injuriesLimited investigationFinal reportCessna 172D · Hague, VAFailure of the pilot to maintain proper alignment with the runway during the landing. Factors relating to the accident were: the crosswind and the proximity of tall corn (crop) to the narrow runway.NTSB ATL95LA149Accident · Serious injuriesLimited investigationFinal reportFantasy Sky Promotions Fantasy 6 · Kingsport, TNThe pilot's inadequate visual lookout.NTSB ANC95LA130Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Ketchikan, AKThe pilot's inadequate preflight preparation and the water in the airplane's fuel system. A factor in the accident was the rough water in the forced landing area.NTSB ANC95FA129Accident · 2 fatalField investigationFinal reportCessna 170 · Coldfoot, AKThe pilot's failure to maintain adequate distance and/or altitude from terrain. Rising mountainous terrain and downdrafts associated with unfavorable wind conditions were factors in the accident.NTSB LAX95LA278Accident · 1 fatalLimited investigationFinal reportFox Peregrine PJ-2 · Minden, NVa failure of the wing flap control system due to inadequate design, which led to an asymmetrical flap deployment during a critical flight condition and in-flight loss of control. A related factor was the lack of a split-flaps warning system.NTSB CHI95LA258Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Aurora, NEthe cracked engine assembly that caused the power loss during a critical phase of flight. Factors associated with this accident were the restricted airplane performance due to the power loss, the airplane's altitude was too low, and remedial action, by, the…NTSB CHI95FA259Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Fifield, WIthe pilot's attempted visual flight into instrument meteorological conditions, which resulted in spatial disorientation and loss of control. A factor was the fog.NTSB ANC95LA128Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Circle, AKThe pilot's premature liftoff during takeoff.NTSB ANC95LA127Accident · No injuriesLimited investigationFinal reportCessna 206 · Sterling, AKFailure of both pilot's to maintain adequate visual lookout. The low angle of the sun was a related factor.NTSB SEA95FA170Accident · No injuriesField investigationFinal reportDornier DO 328-100 · Portland, ORinsufficiently defined information from the manufacturer and operator concerning the landing/taxi procedures.NTSB NYC95FA181Accident · 1 fatalField investigationFinal reportPiper PA-28-236 · Rehoboth, MAThe pilot's inadvertent flight into hazardous weather, which subsequently resulted in exceeding the design stress limits of the airplane and an in-flight breakup. Factors relating to the accident were: embedded thunderstorms, turbulence, and failure of the…NTSB LAX95LA277Accident · 1 fatalLimited investigationFinal reportJenkins Long E-Z · Prescott, AZthe pilot's failure to properly lean the engine for best power, his premature rotation of an over gross aircraft on an uphill runway, and his delay in aborting the takeoff.NTSB FTW95LA327Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Monroe, LAThe pilot's improper positioning of the fuel selector resulting in fuel starvation and the failure of the pilot to follow the published emergency procedures for propeller feathering. Factors were the fence and the trees.NTSB CHI95LA265Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Wyatt, MOthe pilot's failure to use carburetor heat which led to carburetor ice. Factors were weather conditions conducive to carburetor icing and the unsuitable terrain encountered during the forced landing.NTSB MIA95LA191Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Holly Springs, MSThe failure of the pilot-in-command to insure the oil dip stick was secure prior to departure resulting in loss of engine oil, overheating of the engine, and loss of engine power.NTSB FTW95LA328Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Searcy, ARThe inadvertent stall as a result of the pilot's failure to maintain airspeed during the approach.NTSB CHI95LA257Accident · No injuriesLimited investigationFinal reportNanchang 18A · Superior Twnshp, MIthe pilot's operation of the airplane with a known deficiency in the fuel selector, and his improper positioning of the fuel selector. A factor relating to the accident was: the fuel selector's restriction of movement.NTSB ANC95LA126Accident · No injuriesLimited investigationFinal reportCessna 206G · Skwentna, AKThe pilot's improper handling of the aircraft (prolonged yawing maneuver during step taxi turn), which resulted in uncovering of the fuel tank outlets and subsequent fuel starvation during takeoff.NTSB ANC95LA123Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Nikiski, AKThe pilot's selection of unsuitable terrain, and his delay in aborting the takeoff. The soft terrain and high grass were related factors.NTSB SEA95LA169Accident · No injuriesLimited investigationFinal reportCessna 172C · Red Lodge, MTThe pilot's failure to maintain airspeed. The pilot's inadequate preflight planning/preparation and selection of unsuitable terrain for landing were factors.NTSB LAX95LA350Accident · No injuriesLimited investigationFinal reportBoeing B75-A75N1 · Van Nuys, CAthe pilot's failure to maintain directional control during landing rollout. Factors which contributed to the loss of control were: the pilot's total lack of experience landing the conventional gear airplane in a crosswind condition, and the crosswind.NTSB LAX95LA276Accident · No injuriesLimited investigationFinal reportNorth American AT-6B · Glendale, AZThe failure of the pilot of the other aircraft to follow pre-briefed instructions and failure to see and avoid the preceding aircraft awaiting takeoff.NTSB CHI95LA256Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Naperville, ILThe pilot's failure to maintain directional control during the takeoff roll. Contributing factors were the pilot's lack or recent experience in tailwheel equipped aircraft and failure to abort the takeoff early enough to prevent the accident.NTSB CHI95FA255Accident · 2 fatalField investigationFinal reportBeech T-34C · Oak Creek, WIthe pilot's failure to maintain an adequate fuel supply, and his failure to maintain airspeed.NTSB ATL95LA146Accident · No injuriesLimited investigationFinal reportCessna 152A · Sanford, FLThe pilot's failure to maintain directional control during the takeoff portion of a touch and go landing.NTSB ANC95LA124Accident · Serious injuriesLimited investigationFinal reportCessna 172A · Chickaloon, AKThe pilot's inadvertent encounter with adverse weather conditions and failure to maintain sufficient altitude/clearance from the terrain to compensate for such conditions. Factors related to the accident were: downdrafts, the proximity of mountainous terrain,…NTSB ANC95LA122Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Kodiak, AKOverload failure of the main landing gear wheel.NTSB SEA95LA168Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Shelley, IDThe left main landing gear tire burst during takeoff.NTSB NYC95LA209Accident · Serious injuriesLimited investigationFinal reportKolb Firestar · Frankfort, NYInflight collision with the ground for undetermined reasons.NTSB NYC95LA180Accident · No injuriesLimited investigationFinal reportWright JUNGSTER-I · Mansfield, MAthe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall and subsequent uncontrolled descent and collision with the terrain.NTSB FTW95LA325Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS-3-17 · Sandia Park, NMThe pilot's improper evaluation of the developing thunderstorm activity. Factors were the weather and the lack of suitable terrain for the precautionary landing.NTSB CHI95LA252Accident · No injuriesLimited investigationFinal reportStevens Acro II · Oshkosh, WIthe failure of the pilot of the Acro II, N40LF, to maintain clearance from the Cessna 172, N5542R.NTSB ATL95LA145Accident · No injuriesLimited investigationFinal reportBell 47G2 · Montrose, GAThe pilot's inadequate preflight planning and visual lookout.NTSB SEA95LA167Accident · 1 fatalLimited investigationFinal reportPederson Silhouette 1 · Corvallis, ORThe pilot's failure to maintain control of the aircraft. A factor in the accident was the pilot performing aerobatics at an altitude inadequate for safe recovery.NTSB SEA95LA166Accident · No injuriesLimited investigationFinal reportCessna 150J · West Jordan, UTThe pilot's failure to refuel the aircraft prior to initiating his cross-country flight resulting in a total power loss due to fuel exhaustion.NTSB NYC95LA179Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Farmingdale, NJthe pilot's improper inflight decision and inaccurate fuel consumption calculations, resulting in a loss of engine power due to fuel exhaustion and a forced landing over unsuitable terrain.NTSB CHI95LA249Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Kingman, KSthe pilot's failure to obtain sufficient airspeed before liftoff, and his delay in aborting the takeoff. A factor relating to the accident was: the pilot's lack of recent flying experience.NTSB CHI95LA246Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Springfield, MOthe partial loss of engine power due to fouled spark plugs as a result of an improper fuel/air mixture. A factor in the accident was the powerlines.NTSB ANC95LA118Accident · Minor injuriesLimited investigationFinal reportCessna 172B · North Pole, AKImproper planning/decision by the pilot, which resulted in fuel exhaustion, when there was an inadequate supply of fuel to reach the destination.NTSB SEA95LA165Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Buhl, IDThe loss of power due to the failure of an engine cylinder. The chemical load was not dumped for undetermined reasons and contributed to the severity of injuries.NTSB SEA95LA159Accident · No injuriesLimited investigationFinal reportCessna 402B · Wenatchee, WAImproper installation (failure to install cotter key) by company maintenance personnel.NTSB LAX95LA275Accident · 1 fatalLimited investigationFinal reportBeech P35 · Elko, NVthe failure of the pilot to maintain airspeed in a turn during high wind conditions while executing a go-around at a low altitude, which resulted in an inadvertent stall and an uncontrolled descent into the ground.