NTSB investigations: Kinner R5 series
4 cases on aircraft whose registry engine model is Kinner R5 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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.
Cases per year
| 1984 | 1 |
|---|---|
| 1987 | 1 |
| 1989 | 2 |
Where
Open the mapLatest 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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('37504')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND 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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('37504')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 353))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 NYC89LA196Accident · Minor injuriesLimited investigationFinal reportRyan ST-3KR · Factoryville, PAInadequate preflight by the pilot and his misjudgement of the fuel supply, which resulted in fuel exhaustion. The ditch was a related factor.NTSB DEN89LA134Accident · Serious injuriesLimited investigationFinal reportRyan ST-3KR · La Salle, COForeign material (insect nest) blocking the fuel system vent, which resulted in a restriction of fuel flow and fuel starvation. A related factor was the alfalfa crop in the emergency landing area.NTSB LAX87FA264Accident · 2 fatalField investigationFinal reportRyan ST3KR · Firebaugh, CAAt about 1650 PDT, the plts of 2 Ryan ST3KR acft depd coalinga on a flt to los banos, CA. At about 1709 PDT, the plt of N48777 made a hand signal to the other plt, pointed toward the ground & entered 'a normal glide.' Subsequently, the plt of N48777…NTSB CHI84LA365Accident · No injuriesLimited investigationFinal reportMeyers OTW · New Athens, OHThe acft nosed over in an open field during a forced landing after the engine quit. 2 witnesses, one an A&P mechanic, reported that there was no evidence of fuel on board the acft after the accident. The plt stated to the highway patrol trooper at the scene…