NTSB investigations, 1985, OR
7 cases where the first occurrence was “Loss of engine power”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 2 |
| 1984 | 2 |
| 1985 | 7 |
| 1986 | 4 |
| 1987 | 2 |
| 1988 | 2 |
| 1991 | 4 |
| 1992 | 4 |
| 1993 | 3 |
| 1994 | 2 |
| 1995 | 5 |
| 1996 | 4 |
| 1997 | 7 |
| 1998 | 7 |
| 1999 | 3 |
| 2000 | 8 |
| 2001 | 4 |
| 2002 | 9 |
| 2003 | 4 |
| 2004 | 6 |
| 2005 | 7 |
| 2006 | 4 |
| 2007 | 7 |
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\" = 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 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" = 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 SEA86LA013Accident · No injuriesLimited investigationFinal reportHiller UH-12D · Reedsport, ORA forced landing downhill was made due to a loss of power. Upon touchdown the right skid broke and the aircraft rolled onto its right side. During engine examination only 1PINT of fuel was remaining in the fuel tank. The engine was test run and no mechanical…NTSB SEA86LA012Accident · No injuriesLimited investigationFinal reportCessna 152 · Ontario, ORA forced landing occurred due to a total loss of power. Landing was accomplished onto a freshly plowed potato field where substantial damage occurred. No reason for the loss of power could be determined.NTSB SEA85LA179Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Yamhill, ORThe eng ceased operating at aprx 40 ft AGL during initial takeoff climb. Investigation disclosed the acft had been fueled with a mixture of automotive fuel and 80/87 avgas. The acft had sat on the ground for over 4 hrs with a surface tem of 95 degs f. a…NTSB SEA85FA137Accident · Serious injuriesField investigationFinal reportHiller UH-12C · Warm Springs, ORDuring a flt from madras, OR to walla walla, WA, a loss of eng power occurred due to a fuel flow problem & the plt made a successful autorotation near Warm Springs, OR. A company mechanic was dispatched to the helicopter & he repaired a loose fuel line…NTSB SEA85LA135Accident · No injuriesLimited investigationFinal reportAlon A2 · Albany, ORDuring takeoff at about 150 feet AGL the engine ceased operating. A forced landing was made and the acft struck a fence prior to touchdown. Inspection of the acft and eng did not reveal any mechanical failure/malfunction. The plt had been using automotive…NTSB SEA85LA107Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Fall Creek, ORThe helicopter sustained substantial damage during a forced landing following a loss of power. According to the plt, the helicopter was refueled aprx 1 hr flt time prior to the accident. Cause of the power loss was not determined.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,…