NTSB investigations, 1983, OR
14 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\") = 1983
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") = 1983 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 SEA84LA022Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Oregon City, ORThe plt, who was an a & p mechanic, had just installed an eng that had been overhauled by someone else. He reported that the pretakeoff & run-up checks were normal. At aprx 250 to 300 ft AGL, during takeoff, the eng began to shake violently & lost power. The…NTSB SEA84LA021Accident · Minor injuriesLimited investigationFinal reportEnstrom F28F · Hillsboro, ORThe acft did a hard landing during autorotation after the engine ran rough and quit at 250 ft AGL during takeoff. The pilot had leaned the mixture, he said, prior to takeoff and he was not sure if he pushed the mixture to full rich when the engine started to…NTSB SEA83LA134Accident · No injuriesLimited investigationFinal reportEnstrom F28A · Lebanon, ORThe helicopter was damaged in a roll-over during a forced landing on a soft plowed field. The pilot stated that he was checking another company pilot and in doing so he abruptly reduced power to simulate engine failure. A total loss of power occurred. The…NTSB SEA83FYM07Accident · Serious injuriesFinal reportMaule M-5-235C · Silverton, ORThe acft landing gear collapsed during a forced landing after an engine failure. The acft had climbed to 1000 ft AGL after takeoff when the pilot switched the fuel selector to the right fuel tank. Immediately the engine quit and switching back to the left…NTSB SEA83LA130Accident · Serious injuriesLimited investigationFinal reportCessna 337B · Dayton, ORThe pilot stated he was demonstrating a 'steep letdown' to his passenger from about 3200 MSL. The descent was with full flaps, landing gear extended and power off on both engines. At about 1200 MSL the pilot leveled off and added power and had none on the…NTSB SEA83LA128Accident · No injuriesLimited investigationFinal reportCessna 152 · Cascade Locks, ORThe acft collided with a guard rail after making a forced landing on a highway during a student solo cross-country flight. The flight had originated at vancouver WA, and the student pilot had been instructed to refuel at pendleton, OR.a landing was made at…NTSB SEA83FYM06Accident · Serious injuriesFinal reportCessna T210L · Hermiston, ORThe acft stalled into the ground in a semi-controlled crash forced landing after the engine quit due to fuel exhaustion.a post accident examination revealed only one ounce of fuel aboard the acft. The acft release form from Boeing aircraft to the pilot for…NTSB SEA83LA136Accident · No injuriesLimited investigationFinal reportSnow S2C · Hepner, ORThe acft slid sideways on a sloping field during a forced landing and damaged a wing. The pilot said he had sprayed two fields and was enroute to spray another when a complete loss of power occurred. The pilot stated that he found no usablefuel in either fuel…NTSB SEA83FYK03Accident · Serious injuriesFinal reportRyan-Navion NAV 4 · Cottage Grove, ORThe acft made a forced landing in a hay field and collaped the landing gear after the engine quit at 500 ft AGL during takeoff climb. During an on scene investigation there was no fuel visible in the rt wing tank. The left wing tank has nofiller access but is…NTSB SEA83LA097Accident · No injuriesLimited investigationFinal reportPiper PA-25-235B · La Grande, ORThe acft stalled about 30 feet AGL during a forced landing after the engine quit from fuel exhaustion. The pilot took the acft for a ferry flight without refueling. It had been flown about 1 hour & 15 minutes. It holds about 36 gallons and burns about 14…NTSB SEA83LA081Accident · No injuriesLimited investigationFinal reportSmith Miniplane · Near Rainier, ORAprx 20 min after takeoff, the engine lost power. Several restarts were initiated; however, the engine would not continue running. During an emergency landing on sandy terrain, the nose gear dug in & the acft nosed over the plt described the loss of power as…NTSB SEA83LA079Accident · No injuriesLimited investigationFinal reportErco 415C · Boring, ORThe aircraft collided with a fence and collapsed the nose gear during a forced landing after the engine lost power in cruise flight. The pilot had departed Oregon city earlier to fly to evergreen airport to fuel the aircraft and then to return to Oregon city.…NTSB SEA83LA050Accident · No injuriesLimited investigationFinal reportCessna 182N · Chiloquin, ORDuring a long straight in approach from about 3 miles out the aircraft lost power. The pilot figured he could not make the runway so he tried for a highway. In diving to avoid wires he drove the nose gear onto the ground. The nose gear was sheared off and the…NTSB SEA83LA036Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Newport, ORThe engine lost power when the pilot was on an extended base leg for landing. From that position, he could not glide to the runway, so he elected to land on a nearby beach. The location of people walking on the beach prevented an upwind landing, so the pilot…