NTSB investigations, 2006, OR
4 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\") = 2006
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") = 2006 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 SEA07CA008Accident · Minor injuriesData collectionFinal reportBeech E-55 · Ontario, ORThe dual loss of engine power due to fuel exhaustion as a result of the pilot's failure to adequately determine the amount of fuel aboard the airplane during his preflight preparation. A contributing factor was the pilot's misjudgment of distance/speed during…NTSB SEA06LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-150 · Ontario, ORThe pilot's inadequate inflight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. Factors were the en route high wind condition and the soft terrain.NTSB SEA06LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Brookings, ORThe pilot's inadequate in flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of engine power. Trees and no suitable terrain for the landing were factors.NTSB SEA06FA038Accident · 1 fatalField investigationFinal reportMooney M20K · North Plains, ORThe pilot's failure to maintain airspeed while maneuvering for a forced landing, resulting in a stall-spin and uncontrolled descent to ground impact. A contributing factor was the loss of engine power due to fuel exhaustion resulting from the pilot's…