NTSB investigations, 1982, OR
11 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\") = 1982
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") = 1982 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 SEA83LA035Accident · No injuriesLimited investigationFinal reportCessna 150G · Scappoose, ORAt about 300 ft AGL after a touch & go the eng quit. The non-pilot owner who was at the controls turned the acft over to the passenger who was a private pilot & he made the forced landing. There was no usuable fuel on board the acft the passenger/pilot…NTSB SEA82DA169Accident · Minor injuriesFinal reportMooney M20E · Government Camp, ORThe pilot stated that the engine power became intermittent during cruise flight. A force landing was attempted on a highway. Upon touchdown, the aircraft skidded off the road and over an embankment. The state police arrived at the accident site shortly after…NTSB SEA82FYM23Accident · No injuriesFinal reportHughes 369HS · Troutdale, ORThe flt originated at the plt's residence 20 mi south of the Troutdale arpt. The plt stated the purpose of the flt was to refuel the acft since he figured he had about 8 gals of fuel on departure. As the acft approached the ground at about 50 ft AGL the plt…NTSB SEA82DA143Accident · No injuriesFinal reportPiper PA-28-161 · Redmond, ORThe student pilot was on a solo cross-country flight from hillsboro, OR to yakima, WA, to Redmond, OR and then return to hillsboro. The pilot reported a number of altitude and course deviations during the first two legs of the cross-country to avoid clouds.…NTSB SEA82DA135Accident · No injuriesFinal reportMooney M20F · Sandy, ORAfter the engine was overhauled, the pilot and a mechanic took off on a test flight. During the takeoff climb the engine lost power and when force landed on soft terrain, the nose and right main landing gear collapsed. An examination revealed that the left…NTSB SEA82FA117Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Portland, ORThe pilot, enrolled in a course for a commercial pilot certificate, was scheduled for a solo flight from seattle to bremerton, Washington and return. He departed at about 1300 PDT. At about 1635 PDT, residents near the crash site reported that they saw and…NTSB SEA82FYM21Accident · No injuriesFinal reportCessna TU206G · Hood River, ORThe eng failed as the plt switched from the left to right tank while turning base. He turned on the boost pump but the eng did not start. He switched back to the left tank & turned on the high boost. The eng failed to start & the acft crashed into an apple…NTSB SEA82FYM18Accident · 2 fatalFinal reportMccall KR-2 · Union, ORReportedly, the aircraft departed la grande, OR with 12 gallons of fuel on board and was flown to baker, OR. Later, the pilot departed baker on a return flight to la grande without refueling. Subsequently, the plane was reported as missing. The next day it…NTSB SEA82FYM16Accident · Minor injuriesFinal reportHughes 369D · Birkenfeld, ORThe pilot stated that the fuel gauge indicated 150 lbs of fuel remaining when he began the flight. Since the drop point was within 2 to 3 minutes of the departure point, he elected to proceed without refueling. While hovering and being guided into the drop…NTSB SEA82FA046Accident · Serious injuriesField investigationFinal reportCessna 177RG · 10 East Of Till, ORDuring flight at 13,000 ft MSL, the engine began losing power. The aircraft was vectored toward the prospect airport near tiller, Oregon. However, about two minutes later, all engine power was lost. During a forced landing, the aircraft struck a dead…NTSB SEA82DA035Accident · No injuriesFinal reportCessna 182P · Creswell, ORDuring preflight the pilot found water in the fuel system. After fuel drainings and sample checks were completed the pilot started the engine and initiated taxi for takeoff. During taxi and engine runup the engine stopped several times. After repeated fuel…