Fatal NTSB investigations, OR
5 cases where the first occurrence was “Loss of engine power”.
Cases per year
| 1985 | 1 |
|---|---|
| 1996 | 1 |
| 2002 | 1 |
| 2006 | 2 |
Where
Latest cases
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.\"eventStateOrRegion\" = 'OR' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350)
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."eventStateOrRegion" = 'OR' AND c."eventCountry" = 'USA' AND c."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350) 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 SEA07LA040Accident · 1 fatalLimited investigationFinal reportTessier Avid Flyer · Hillsboro, ORThe loss of engine power during maneuvering flight due to carburetor icing, and inadvertent flight into instrument meteorological conditions. Factors were the ambient weather conditions conducive to carburetor icing and fog.NTSB SEA06FA067Accident · 1 fatalField investigationFinal reportKaman K-1200 · Dayville, ORThe improper overhaul of the reduction gear box assembly and improper installation of the N1 seal and nut assembly lockcup by maintenance personnel, which resulted in failure of the reduction gear box and a total loss of engine power. A contributing factor…NTSB SEA02LA072Accident · 1 fatalLimited investigationFinal reportGallagher Taylor "Coot" · Creswell, ORA loss of engine power due to oil starvation followed by the pilot's failure to maintain aircraft control during the initial climb shortly after takeoff. An improper engine modification was a factor.NTSB SEA97LA022Accident · 1 fatalLimited investigationFinal reportCollier Q200 · Estacada, ORinadequate maintenance adjustment by the owner/pilot/mechanic, by not using safety wire to secure the throttle arm clamping screw, which resulted in a loose clamping screw and rotation of the throttle arm with respect to the butterfly valve shaft. The lack of…NTSB SEA85FA056Accident · 4 fatalField investigationFinal reportGulfstream AC-680F · Central Point, ORThe plt reported a loss of power on both engs during descent to land. Aprx 3 mins prior, twr gave plt option of 'straight-in' to rwy 14 or reg pattern to rwy 32. The plt hesitated & said 'just a minute' & twr offered wind info as '210 at 13.' Plt replied,…