NTSB investigations
2,248 cases where NTSB found Not determined, general.
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 WHERE c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '05000000')) 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 WHERE c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '05000000')) 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 NYC08LA245Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Pelham, GAA partial loss of engine power for undetermined reasons which led to a forced landing in unsuitable terrain.NTSB LAX08LA304Accident · No injuriesLimited investigationFinal reportBeech N35 · The Dalles, ORA collapse of the right main landing gear for undetermined reasons.NTSB MIA08LA138Accident · 2 fatalLimited investigationFinal reportColyaer SL Freedom S100 · Limestone, ALThe pilot's loss of aircraft control for undetermined reasons while making a water landing.NTSB NYC08FA242Accident · Minor injuriesField investigationFinal reportBeech V35B · Lancaster, PAA complete loss of engine power for undetermined reasons.NTSB MIA08LA134Accident · 1 fatalLimited investigationFinal reportDouglas A. Pohl Lancair IV-P · Hollywood, FLA loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to maintain aircraft control which resulted in an aerodynamic stall.NTSB NYC08FA239Accident · 1 fatalField investigationFinal reportJahns Vans RV-7 · Neptune, NJAn in-flight loss of control for undetermined reasons.NTSB NYC08FA238Accident · 1 fatalField investigationFinal reportCessna 152 · Rossville, TNUndetermined.NTSB DFW08CA181Accident · No injuriesData collectionFinal reportPiper PA-22/20 · Peyton, COLanding gear collapse during the landing roll for undetermined reasons.NTSB CHI08CA183Accident · No injuriesData collectionFinal reportChallenger II · Williamsfield, ILThe loss of engine power for undertermined reasons and the unsuitable landing area encountered during the forced landing. Contributing to the accident were the trees and the residence.NTSB CHI08LA180Accident · Minor injuriesLimited investigationFinal reportSmith Aerostar 601P · Alexandria, MNThe loss of engine power for undetermined reasons. Contributing to the accident was the unsuitable terrain for the forced landing.NTSB CHI08CA188Accident · No injuriesData collectionFinal reportCessna 177A · Rhinelander, WIThe loss of engine power for an undetermined reason. A factor was the berm encountered during the forced landing.NTSB CHI08CA175Accident · No injuriesData collectionFinal reportBeech A36 · Dwight, ILThe loss of engine power for undetermined reasons. Contributing to the accident was the highway signpost that the airplane impacted during the landing rollout.NTSB DFW08LA176Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300T · Cookson, OKThe partial loss of engine power during initial takeoff climb for undetermined reasons. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB CHI08LA190Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-200 · Baldwin, WIUndetermined.NTSB DFW08LA169Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Olathe, KSA loss of engine power for undetermined reasons.NTSB ANC08LA078Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Iliamna, AKA loss of engine power for an undetermined reason during an approach for landing, which resulted in a forced landing and collision with terrain.NTSB NYC08LA226Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Ganesvoort, NYA loss of engine power for undetermined reasons.NTSB CHI08LA171Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Watseka, ILThe loss of engine power for undetermined reasons.NTSB ANC08LA077Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Willow, AKA partial loss of engine power during an aborted landing for an undetermined reason, which resulted in a collision with terrain and subsequent nose over.NTSB SEA08CA154Accident · Minor injuriesData collectionFinal reportUetz, Walter Spitfire II · Kamiah, IDThe total loss of engine power for undetermined reasons, and the pilot's failure maintain the proper descent rate during the last part of his approach to a forced landing in an open hayfield.NTSB DEN08LA103Accident · No injuriesLimited investigationFinal reportCessna A188B · Lyons, KSthe loss of engine power for undetermined reasons. A contributing factor was the dirt embankment.NTSB DFW08CA163Accident · No injuriesData collectionFinal reportCessna CE-152 · Foss, OKA total loss of engine power for undetermined reasons.NTSB NYC08FA211Accident · Serious injuriesField investigationFinal reportAvid Mark IV Aerobat · Niceville, FLThe pilot's loss of control during landing for undetermined reasons.NTSB ANC08LA074Accident · No injuriesLimited investigationFinal reportLake L-4 · Girdwood, AKA partial loss of engine power for an undetermined reason, which resulted in a forced landing. Contributing to the accident was rough and uneven terrain.NTSB CHI08CA170Accident · No injuriesData collectionFinal reportKindig Sonex · Metropolis, ILThe loss of engine power for undermined reasons and the low altitude at the time of engine power loss while turning. An additional cause was the proper touchdown point not attained by the pilot, A contributing factor was the runway lights.NTSB NYC08LA204Accident · Minor injuriesLimited investigationFinal reportCessna 421C · Greenville, NCThe malfunction and premature retraction of the landing gear for undetermined reasons.NTSB LAX08LA161Accident · Minor injuriesLimited investigationFinal reportDavison Vari Eze · Arlington, WAA loss of engine power for undetermined reasons.NTSB CHI08LA151Accident · No injuriesLimited investigationFinal reportBell 47D1 · Carrollton, OHThe airframe vibration for an undetermined reason.NTSB SEA08LA147Accident · No injuriesLimited investigationFinal reportAero Commander 690A · Tacoma, WAThe collapse of the right main landing gear for undetermined reasons.NTSB SEA08FA146Accident · 2 fatalField investigationFinal reportCessna 172R · Monticello, UTThe in-flight collision with mountainous terrain for undetermined reasons. *This report was modified on December 10, 2009.NTSB MIA08LA109Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Durham, NCThe pilot's failure to maintain clearance from trees while approaching to land.NTSB DFW08CA155Accident · No injuriesData collectionFinal reportAyres S2R-T34 · Des Arc, ARA total loss of engine power while maneuvering for undetermined reasons.NTSB SEA08LA137Accident · 1 fatalLimited investigationFinal reportNolan RV-4 · Tolani Lake, AZAn in-flight collision with terrain for undetermined reasons.NTSB SEA08FA135Accident · 1 fatalField investigationFinal reportBeech 1900C · Billings, MTThe pilot's failure to maintain aircraft control during the initial climb for undetermined reasons.NTSB MIA08LA105Accident · 1 fatalLimited investigationFinal reportAviate Raptor · Bealeton, VAAn in-flight loss of control for undetermined reasons.NTSB DFW08CA150Accident · Minor injuriesData collectionFinal reportCortesy, John E Airborne Edge-X · San Juan Pueblo, NMThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. Contributing to the accident was the loss of engine power for undetermined reasons.NTSB NYC08LA185Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA-5A · Lewisburg, TNA partial loss of engine power for an undetermined reason during the initial climb, and the pilot's failure to maintain adequate airspeed while attempting to return to the airport resulting in an aerodynamic stall.NTSB DEN08LA090Accident · No injuriesLimited investigationFinal reportDeHavilland DH112 Venom · Hudson, COThe loss of engine power for reasons undetermined. Contributing to the damage of the airplane were the three ditches and the lack of suitable terrain for a forced landing.NTSB DFW08CA146Accident · No injuriesData collectionFinal reportAir Tractor 401-0860 · Mumford, TXA total loss of engine power for undetermined reasons.NTSB NYC08CA181Accident · No injuriesData collectionFinal reportCessna 172 M · Hampton, NJA loss of engine power for undetermined reasons.NTSB LAX08LA139Accident · No injuriesLimited investigationFinal reportHughes 369FF · Kekaha, HIA loss of engine power for undetermined reasons.NTSB SEA08LA134Accident · Serious injuriesLimited investigationFinal reportHawker Beechcraft E-55 · Coeur d'Alene, IDLoss of engine power for undetermined reasons.NTSB CHI08FA135Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Stevens Point, WIThe partial loss of engine power for undetermined reasons.NTSB SEA08LA133Accident · Minor injuriesLimited investigationFinal reportThrush S-2R · Holtville, CAThe loss of oil pressure for undetermined reasons.NTSB DFW08LA135Accident · Serious injuriesLimited investigationFinal reportBailey Varieze · Phillipsburg, KSThe pilots failure to maintain aircraft control during an emergency landing. Contributing factors were the reported smoke and prevailing gusty wind conditions.NTSB CHI08LA129Accident · No injuriesLimited investigationFinal reportCessna 208B · Ada, MIA loss of engine power for undetermined reasons.NTSB SEA08LA127Accident · 1 fatalLimited investigationFinal reportThorp T-18 · Kent, WAThe loss of engine power for undetermined reasons. Contributing to the accident were the lack of a suitable landing area and the pilot's failure to maintain an adequate airspeed while maneuvering in response to the loss of engine power.NTSB CHI08CA127Accident · Minor injuriesData collectionFinal reportCessna 140 · Burlington, WIA loss of engine power for undetermined reasons. Contributing to the accident was the low altitude at the time of the loss of engine power.NTSB ANC08LA063Accident · Serious injuriesLimited investigationFinal reportShaffstall Kolb Firestar II · Concord, NCA loss of engine power for an undetermined reason, which resulted in a forced landing and collision with terrain.NTSB MIA08LA096Accident · 1 fatalLimited investigationFinal reportGarrett Gerald P Cozy Mark IV · Jekyll Island, GAControlled flight into water for undetermined reasons.