Fatal NTSB investigations: Kinner R5 series

14 cases on aircraft whose registry engine model is Kinner R5 series. 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

19652026

Fatal NTSB investigations: Kinner R5 series per year, 1965–2026: 14 cases
1965	1
1966	1
1967	1
1970	1
1971	1
1973	1
1974	1
1977	1
1987	1
2000	1
2003	1
2011	1
2015	1
2020	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 c."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('37504')) 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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('37504'))
  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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('37504'))
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 CEN20WA441Accident · 2 fatalClass 5 · ForeignRyan Aeronautical ST3KR · Les Chariots, FranceFeb 23, 2020 · N53018 · Destroyed NTSB WPR15LA233Accident · 1 fatalLimited investigationFinal reportRyan Aeronautical ST3KR · Hollister, CAThe pilot's failure to observe the runway environment while operating in the traffic pattern and his subsequent failure to maintain clearance from a lawnmower on the runway during the landing roll. Contributing to the accident was the lawnmower operator's…Aug 6, 2015 · N48701 · Substantial damage NTSB WPR11LA096Accident · 1 fatalLimited investigationFinal reportRyan Aeronautical ST3KR · Warner Springs, CAThe pilot's failure to maintain clearance from the wind sock pole during landing.Jan 11, 2011 · N57027 · Substantial damage NTSB NYC04LA021Accident · 2 fatalLimited investigationFinal reportFleet 16B · Fishers Island, NYThe pilot's failure to maintain adequate clearance while maneuvering, which resulted in a collision with water.Nov 2, 2003 · N80656 · Destroyed NTSB LAX01LA020Accident · 1 fatalLimited investigationFinal reportRyan ST3KR · Georgetown, CAThe airplane's encounter with a strong updraft at the end of the runway that induced an increase in the wing's angle of attack to the critical point, which resulted in an inadvertent stall and spin.Oct 21, 2000 · N50870 · Destroyed 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…Jul 13, 1987 · N48777 · Destroyed NTSB FTW77FA054Accident · 1 fatalClosedRyan ST-3KR · San Angelo, TXMay 15, 1977 · N47432 · Destroyed NTSB MIA74AM052Accident · 2 fatalClosedRyan PT-22 · Auburn, ALJan 1, 1974 · N170P · Destroyed NTSB CHI73AC095Accident · 1 fatalClosedRyan ST-3KR · Greenfield, INJun 9, 1973 · N47368 · Destroyed NTSB LAX72AL007Accident · 2 fatalClosedRyan ST-3KR · Brmuda Duns, CAJul 21, 1971 · N46745 · Destroyed NTSB SEA70AS047Accident · 3 fatalClosedMeyers OTW · Scappoose, ORJun 14, 1970 · N34324 · 2 aircraft · Destroyed NTSB CHI68A0007Accident · 2 fatalClosedRyan ST-3KR · Palatine, ILJul 15, 1967 · N46504 · Destroyed NTSB SEA67A0001Accident · 2 fatalClosedRyan ST-3KR · Beaverton, ORJul 3, 1966 · N50879 · Destroyed NTSB LAX65A0067Accident · 1 fatalClosedRyan ST-3KR · Kipley, CAFeb 14, 1965 · N57015 · Destroyed