Skip to content

NTSB investigations: Amateur-built UNKNOWN ENG, OR

68 cases on aircraft whose registry engine model is Amateur-built UNKNOWN ENG. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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 c."eventStateOrRegion" = 'OR' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('99999')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 c.\"eventStateOrRegion\" = 'OR' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('99999'))
  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 c."eventStateOrRegion" = 'OR' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('99999'))
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 SEA83FA141Accident · 1 fatalField investigationFinal reportMonnett - Larsen Moni · Albany, ORThe home built, powered glider was being flown on a local test flight. According to witnesses, the acft was in unpowered flt (gliding) when it entered a descent & crashed. At about the same time it began descending, they observed something separate from the…Jun 30, 1983 · N83GL · Destroyed NTSB SEA83LA011Accident · No injuriesLimited investigationFinal reportBrantly 305 · Hillsboro, ORThe tail skid hit the ground hard during landing. This caused the helicopter to bounce, and the left wheel contacted the ground causing the helicopter to turn sideways. The main rotor contacted the tail rotor, destroying both tail and main rotor blades.Oct 23, 1982 · N16616 · Substantial damage NTSB SEA82DA110Accident · No injuriesFinal reportRockwell Int'T S2R · Adrian, ORThe pilot landed on a dirt strip that had just been bladed. After touching down in a 3-point attitude, the aircraft rolled about 100 ft and then veered to the left. The pilot stated that he could not correct the situation with right brake and rudder, and…Jul 13, 1982 · N5610X · Substantial damage 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…Jun 6, 1982 · N54622 · Destroyed NTSB SEA82DA047Accident · No injuriesFinal reportSikorsky S-58J · Siletz, ORAfter lift-off with a 3000 pound external sling load, a "pop" was heard followed by low-level vibration. Rotor RPM decayed and an autorotation was effected to a forced landing in a revine. Postcrash inspection revealed a failure of the engine drive "short…Apr 6, 1982 · N47246 · Destroyed NTSB SEA82DYK02Accident · No injuriesClosedPiper PA-24 · Gold Beach, OROct 18, 1981 · N7686P · Substantial damage NTSB SEA81DYM39Accident · No injuriesClosedGeo. Mccall KR-2 · La Grande, ORAug 30, 1981 · N54622 · Substantial damage NTSB SEA81FYK17Accident · Serious injuriesClosedPiper PA-12 · Bend, ORAug 28, 1981 · N7621H · Destroyed NTSB SEA81FYK08Accident · Minor injuriesClosedPiper PA-22 · Medford, ORApr 30, 1981 · N7712D · Substantial damage NTSB SEA81FYK07Accident · Serious injuriesClosedHiller Acft UH-12E · Umpqua, ORMar 18, 1981 · N90467 · Substantial damage NTSB SEA79DYM04Accident · No injuriesClosedSoloy UH12E · Molalla, ORNov 2, 1978 · N5381V · Substantial damage NTSB SEA77FYK06Accident · No injuriesClosedCessna 182 · Burns, ORMay 14, 1977 · N3885D · 2 aircraft · Substantial damage NTSB SEA71DWA33Accident · No injuriesClosedCessna 140 · Tigard, ORApr 1, 1971 · N76294 · Substantial damage NTSB SEA70DVQ02Accident · No injuriesClosedHiller Acft UH-12E · Greenleaf, ORApr 4, 1970 · N5381V · Destroyed NTSB SEA70D0065Accident · No injuriesClosedTravel Air E4000 · Nyssa, ORJul 28, 1969 · N477N · Substantial damage NTSB SEA68D0052Accident · Serious injuriesClosedCessna 150 · Albany, ORMay 21, 1967 · N8727G · No damage NTSB SEA66F0230Accident · No injuriesClosedCessna 172 · Junction City, ORFeb 13, 1966 · N8454X · Substantial damage NTSB SEA66F0045Accident · Minor injuriesClosedPiper PA-18A · Culver, ORMay 19, 1965 · N8568D · Destroyed