NTSB investigations, 1995, 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\") = 1995
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") = 1995 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 SEA96FA012Accident · Serious injuriesField investigationFinal reportBeech A-36 · Newport, ORthe pilot's inadvertent shut-off of the fuel mixture control. Factors contributing to the accident were: the pilot's failure to perform adequate remedial action to regain engine power, his lack of familiarity with the accident airplane, and his failure to…NTSB SEA96LA004Accident · No injuriesLimited investigationFinal reportVans RV-6T · North Plains, ORFuel starvation due to the failure of the left tank fuel quantity sending unit which resulted in a false indication of fuel quantity. A factor was the lack of suitable terrain for the forced landing.NTSB SEA96LA003Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Mulino, ORthe failure of the pilots to use carburetor heat during a reduced power descent. A factor was the carburetor icing conditions.NTSB SEA95LA081Accident · No injuriesLimited investigationFinal reportCessna 180D · Nyssa, ORFuel exhaustion due to the pilot's failure to refuel en route.NTSB SEA95LA060Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Albany, ORThe pilot's failure to use carburetor heat. Factors include icing conditions and the dark night light conditions.NTSB SEA95LA044Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Salem, ORFuel starvation due to inadequate supervision of the dual student by the pilot-in-command when the dual student improperly adjusted the fuel selector position.