NTSB investigations, 1985, OR
4 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 4 |
| 1984 | 2 |
| 1985 | 4 |
| 1986 | 2 |
| 1987 | 3 |
| 1988 | 3 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 4 |
| 1992 | 2 |
| 1993 | 3 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 2 |
| 1998 | 2 |
| 2000 | 1 |
| 2002 | 1 |
| 2003 | 2 |
| 2005 | 1 |
| 2007 | 1 |
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 year(c.\"eventDate\") = 1985
AND c.\"eventStateOrRegion\" = 'OR' AND c.\"eventCountry\" = 'USA'
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\" = 351)
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 year(c."eventDate") = 1985 AND c."eventStateOrRegion" = 'OR' AND c."eventCountry" = 'USA' 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" = 351) 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 SEA86LA026Accident · No injuriesLimited investigationFinal reportHughes 269C · Brooks, ORA total loss of power occurred due to the number 4 cylinder failing. A tail boom strike occurred during a hard landing in a parking lot, severing the tail boom.NTSB SEA85LA097Accident · No injuriesLimited investigationFinal reportHiller 12E · Myrtle Point, ORDuring a CFR 137 flight a total loss of power occurred with an audible screech coming form the engine area. Autorotation was made and the acft was landed into a hevily treed area with steep terrain. During engine tear down a fractured impeller was found.…NTSB SEA85LA077Accident · No injuriesLimited investigationFinal reportGrumman G-164-A · Dufur, ORA loss of power occurred during aerial application and a forced landing was made onto a field. The right main gear sank into a hole and was torn off. The acft then flipped inverted. The throttle leakage was found to be broken.NTSB SEA85LA042Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Troutdale, ORShortly after takeoff plt felt a 'tick' in the engine. Plt reduced pwr and headed back to Troutdale. Engine quit over the threshold of rwy 07 as plt was making a 360 deg turn. Acft touched down short of rwy 07 contacting small bushes and trees. Inspection…