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 CEN11LA552Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Amarillo, TXA loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN11FA562Accident · No injuriesField investigationFinal reportAir Tractor AT-301 · Nekoosa, WIA total loss of engine power during initial climb for undetermined reasons.NTSB WPR11LA366Accident · No injuriesLimited investigationFinal reportAyres S2R-600 · Hazelton, IDPartial loss of engine power for undetermined reasons.NTSB CEN11LA543Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Washington, IAThe loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB ERA11LA434Accident · Minor injuriesLimited investigationFinal reportNord Stampe SV4C · Rhinebeck, NYA total loss of engine power for undetermined reasons.NTSB CEN11WA592Accident · 1 fatalForeign investigationSocata TB10 · Kufstein, AustriaUnder the jurisdiction and control of the Austrian government.NTSB CEN11LA541Accident · No injuriesLimited investigationFinal reportWeatherly 620B · Hettinger, NDInternal failure of the engine for undetermined reasons.NTSB ERA11LA427Accident · 1 fatalLimited investigationFinal reportTL Ultralight Sro Sting S3 · Sarasota, FLThe inability of the pilot-in-command (PIC) to recover from an inadvertent spin following a stall demonstration for reasons that could not be determined because aircraft and engine examinations did not reveal any anomalies that would have precluded recovery…NTSB ERA11FA426Accident · 1 fatalField investigationFinal reportTaylorcraft BL-65 · Winterville, NCA loss of airplane control for undetermined reasons as the autopsy was unable to reveal any definitive conditions that would have led to the loss of control.NTSB CEN11FA505Accident · 2 fatalField investigationFinal reportPiper J3L-65 · Van Dyne, WIThe pilot’s inability to maintain airplane control while maneuvering for reasons that could not be determined from the available evidence.NTSB ANC11LA068Accident · No injuriesLimited investigationFinal reportCessna 185 · Kenai, AKThe loss of engine power for an undetermined reason, resulting in the ditching and sinking of the airplane in ocean waters.NTSB ERA11LA417Accident · Serious injuriesLimited investigationFinal reportRyan Aeronautical ST3KR · Sagaponack, NYThe loss of engine power for undetermined reasons.NTSB CEN11LA522Accident · No injuriesLimited investigationFinal reportCessna 172B · Middleton, WIThe total loss of engine power during climb after takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN11LA544Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT802 · Ullin, ILThe loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN11LA499Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Fergus Falls, MNThe total loss of engine power for reasons that could not be determined because the airplane came to rest inverted in water.NTSB ERA11LA411Accident · No injuriesLimited investigationFinal reportCessna 150M · Elizabethtown, KYA total loss of engine power for undetermined reasons.NTSB CEN11LA487Accident · No injuriesLimited investigationFinal reportAyres S2R · Burlington, COA loss of engine power for undetermined reasons.NTSB ANC11FA065Accident · 1 fatalField investigationFinal reportPiper PA-12 · Delta, AKThe pilot's decision to make a low-altitude turn back to the airport following a loss of engine power, which resulted in an aerodynamic stall and loss of control. Contributing to the severity of the pilot's injuries was the separation of the pilot's seat…NTSB CEN11LA488Accident · Minor injuriesLimited investigationFinal reportDixon Volksplane VP-1 · Jackson, MIA partial loss of engine power during initial climb after takeoff for undetermined reasons.NTSB CEN11LA490Accident · No injuriesLimited investigationFinal reportDarrow Stephen AL-6 · Peyton, COThe loss of engine power during the descent for reasons that could not be determined because a thorough examination of the engine could not be completed due to the remote accident site.NTSB ANC11LA060Accident · Serious injuriesLimited investigationFinal reportSonex / John D. McCarter Waiex · Sterling, AKThe pilot's failure to maintain sufficient airspeed to avoid an aerodynamic stall following a loss of engine power for undetermined reasons.NTSB WPR11LA307Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Columbia, CAThe airplane’s failure to climb at a sufficient rate to clear trees and terrain beyond the end of the runway for reasons that could not be determined because postaccident examination did not reveal any mechanical malfunctions or failures that would have…NTSB ERA11LA400Accident · No injuriesLimited investigationFinal reportFessenden Alfred Expermental RV-4 · Fort Drum, FLA total loss of engine power for undetermined reasons.NTSB ERA11FA374Accident · 1 fatalField investigationFinal reportBinkley Richard Sonex · Calhoun, GAThe total loss of engine power for reasons that could not be determined because postimpact fire damage precluded a thorough examination of the engine.NTSB CEN11LA455Accident · No injuriesLimited investigationFinal reportCouvillion S-17 · Toledo, OHThe loss of control during initial climb for undetermined reasons, which resulted in a hard landing.NTSB ERA11LA399Accident · No injuriesLimited investigationFinal reportCessna 182K · Stevensville, MDA total loss of engine power during initial climb for undetermined reasons.NTSB ERA11CA373Accident · No injuriesData collectionFinal reportLeatherman Karl L Zodiac CH 601 HDS · Gray Court, SCThe total loss of engine power due to the failure of the radiator coolant supply fitting.NTSB CEN11LA449Accident · Minor injuriesLimited investigationFinal reportAbbey Victor RV9-A · Leander, TXThe partial loss of engine power for reasons that could not be determined because examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN11LA452Accident · Minor injuriesLimited investigationFinal reportCessna A188A · Estelline, SDThe pilot’s failure to maintain control of the airplane during takeoff for undetermined reasons because the pilot did not recall the accident.NTSB WPR11LA291Accident · Serious injuriesLimited investigationFinal reportRichard Challenger II · Moses Lake, WAA loss of engine power during the initial climb for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR11LA284Accident · No injuriesLimited investigationFinal reportCessna 172S · Palo Alto, CAA total loss of engine power for undetermined reasons during the landing approach over unsuitable terrain.NTSB WPR11LA278Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Blackfoot, IDA partial loss of engine power during takeoff for undetermined reasons.NTSB WPR11LA272Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Hogeland, MTCollision with the ground while maneuvering at low altitude for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN11WA407Accident · 2 fatalForeign investigationPiper PA-39 · Mont Agel, FranceUnder the jurisdiction and control of the French government.NTSB ERA11LA342Accident · Minor injuriesLimited investigationFinal reportGrumman American Avn. AA-5A · Linden, NCA partial loss of engine power during initial climb for undetermined reasons.NTSB CEN11LA385Accident · No injuriesLimited investigationFinal reportWiley C W RV-6A · Colgate, OKThe loss of engine power for undetermined reasons.NTSB CEN11WA394Accident · 1 fatalForeign investigationAmerican Blimp A60PLUS · Reichelheim, GermanyUnder the jurisdiction and control of the German government.NTSB CEN11LA484Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Cash, ARA loss of engine power for undetermined reasons.NTSB CEN11LA381Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Canton, TXThe loss of fuel pressure for undetermined reasons, which resulted in a loss of engine power.NTSB WPR11LA246Accident · No injuriesLimited investigationFinal reportScottish Series 100 MDL 101 · Chandler, AZA loss of engine power during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB ERA11LA325Accident · Minor injuriesLimited investigationFinal reportClamar Floats CA-4 · Merritt Island, FLThe loss of engine power during takeoff for reasons that could not be determined because a postaccident examination could not be performed before the airplane was disassembled.NTSB WPR11LA253Accident · No injuriesLimited investigationFinal reportCessna A188B · Pine Bluffs, WYA partial loss of engine power during takeoff for reasons that could not be determined because postaccident examination did not reveal any mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN11LA388Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Ironton, OHThe total loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN11LA365Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 (PT17) · Freemont, MIThe pilot’s failure to attain a positive climb rate following takeoff for reasons that could not be determined because the propeller was not provided for further examination. Contributing to the accident was the pilot's impairment from alcohol.NTSB CEN11LA356Accident · Minor injuriesLimited investigationFinal reportBell 206 · Walton, KSA loss of engine power for undetermined reasons because postaccident examination of the airframe and engine revealed no anomalies.NTSB ERA11FA312Accident · 4 fatalField investigationFinal reportBeech 58 · Murphy, NCAn in-flight fire that mostly likely occurred in the right front cockpit area behind the instrument panel and below the glare shield; the origin of the fire could not be determined because of the extensive fire damage.NTSB CEN11LA361Accident · No injuriesLimited investigationFinal reportFlournoy Martin R Flournoy MR S1S · Colorado Springs, COThe pilot’s loss of directional control during the landing rollout due to failure of the tailwheel assembly for undetermined reasons.NTSB CEN11LA364Accident · Minor injuriesLimited investigationFinal reportPiper PA30 · Phillipsburg, OHThe pilot’s failure to maintain directional control during takeoff following a loss of left engine power for undetermined reasons.NTSB CEN11LA350Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-160 · Frederick, OKAn in-flight fire for undetermined reasons.NTSB ERA11LA301Accident · No injuriesLimited investigationFinal reportLeigh S-6 Coyote II · New Kent, VAA total loss of engine power for undetermined reasons.