NTSB investigations: Cuyuna ALL MDLS A/B, 1983

3 cases on aircraft whose registry engine model is Cuyuna ALL MDLS A/B. 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 per year

19822026

NTSB investigations: Cuyuna ALL MDLS A/B, 1983 per year, 1982–2026: 14 cases
1982	1
1983	3
1984	1
1987	2
1989	1
1991	1
1993	2
1997	1
2001	1
2003	1

Where

Open the map

Latest cases

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 year(c."eventDate") = 1983 AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('19050')) 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 year(c.\"eventDate\") = 1983
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('19050'))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('19050'))
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 MKC83LA226Accident · No injuriesLimited investigationFinal reportEipper Quicksilver · Wichita, KSThe instructor plt (CFI) & student were on a dual instructional flt, using a registered, 2 place, ultralight acft with a single control stick. According to the CFI, the student was making a takeoff toward the southwest when the acft encountered a gust of wind…Sep 22, 1983 · N3150X · Substantial damage NTSB ATL83LA363Accident · Minor injuriesLimited investigationFinal reportEipper Quicksilver MX II · Manteo, NCThe plt reported that while he was demonstrating a stall, the eng lost power & would not recover. Subsequently, he landed in a marsh & the ultralight acft nosed over. During an exam, water was found in the carburetor & fuel pump. The fuel tank cap was…Sep 10, 1983 · N242KH · Substantial damage NTSB MIA83LA100Accident · No injuriesLimited investigationFinal reportQuicksilver Quicksilver MX II · Lakeland, FLThe acft collided with a sand hill at the departure end of the runway when the acft failed to accelerate sufficiently following a partial power loss during takeoff. According to the operator spark plug fouling in the engine was the cause of the partial power…Mar 14, 1983 · N3132S · Substantial damage