NTSB investigations, 1985, OR
6 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.
Cases per year
| 1982 | 11 |
|---|---|
| 1983 | 14 |
| 1984 | 12 |
| 1985 | 6 |
| 1986 | 5 |
| 1987 | 4 |
| 1988 | 5 |
| 1989 | 2 |
| 1990 | 10 |
| 1991 | 6 |
| 1992 | 4 |
| 1993 | 7 |
| 1994 | 2 |
| 1995 | 6 |
| 1996 | 1 |
| 1997 | 7 |
| 1998 | 2 |
| 1999 | 6 |
| 2000 | 1 |
| 2001 | 4 |
| 2002 | 1 |
| 2003 | 4 |
| 2004 | 1 |
| 2005 | 2 |
| 2006 | 4 |
| 2007 | 3 |
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\" = 353)
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" = 353) 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 SEA86LA005Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Medford, ORThe acft collided with rocky terrain during an attempted forced landing following a loss of pwr. A witness reported seeing the acft in a steep descending left turn at an alt of aprx 100 ft AGL. The descent continued until the left wing contacted the terrain.…NTSB SEA85LA227Accident · No injuriesLimited investigationFinal reportBeech J35 · Ontario, ORThe plt was flying the acft at a low alt for the purpose of spotting game. The eng ceased operating shortly after switching fuel tanks. The plt stated during a telephone interview that he inadvertently switched the fuel selector to the off position. The acft…NTSB SEA85LA215Accident · No injuriesLimited investigationFinal reportVarga 2150A · Vale, ORThe acft nosed down after the nose gear collapsed during a forced landing on a dirt road following a loss of pwr. The plt reported that aprx 1 hr into the x-country flt he noted the fuel gages indicated 1/2 full on each tank. A state trooper reported he…NTSB SEA85LA123Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Wamic, ORA forced landing was made following a loss of pwr. The acft contacted two fences, a ditch then nosed over during the forced landing. Post accident inspection revealed no fuel in the carburetor float chamber or in the accelerator pump chambers.NTSB SEA85FYM02Accident · Serious injuriesFinal reportRingsdorf-Mcconnell VARI-EZE · Eugene, ORThe acft has a fuselage fuel tank which holds only two gallons as well as two wing fuel tanks. The pilot departed the airport on the fuselage tank and the engine ceased operating before he realized he needed to change the fuel selector. An unsuccessful…NTSB SEA85LA101Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Bandon, ORThe plt was ferrying the acft to Bandon to have the landing gear repaired. The flt was made with the gear secured in the down position. The acft had locking fuel caps & the plt did not visually check the fuel level before taking off; instead, he relied of the…