NTSB investigations: Kinner R5 series, TX
11 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.
Cases per year
| 1964 | 1 |
|---|---|
| 1965 | 1 |
| 1971 | 1 |
| 1974 | 1 |
| 1977 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1990 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 2002 | 1 |
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.\"eventStateOrRegion\" = 'TX' 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 ('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."eventStateOrRegion" = 'TX' 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 ('37504'))
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 FTW02LA220Accident · Serious injuriesLimited investigationFinal reportFleet 7 Deluxe · Canyon, TXThe loss of engine power as a result of the malfunction of the magneto switch.NTSB FTW96LA278Accident · Serious injuriesLimited investigationFinal reportRyan PT-22 · Krum, TXthe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A factor was his lack of recent experience in the make and model of airplane.NTSB FTW95LA142Accident · Minor injuriesLimited investigationFinal reportRyan Aeronautical ST3-KR · Blue Ridge, TXThe loss of engine power for undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB FTW90LA121Accident · No injuriesLimited investigationFinal reportCessna 140 · Fabens, TXInadequate visual lookout by the pilots of both aircraft, which resulted in a failure of each pilot to see-and-avoid the other aircraft. A factor related to the accident was: failure of the ryan ST-3KR pilot to make traffic advizories while entering the…NTSB FTW86LA170Accident · Minor injuriesLimited investigationFinal reportRyan PT-22 · Kerrville, TXWhile arriving for a 'fly-ing' at an uncontrolled arpt, the plt of a PT-22, N48331, turned onto final apch after the plt of a preceding acft had turned off of the rwy. At about the same time, the plt of an unregistered ultralight gyrocopter taxied onto the…NTSB FTW85LA285Accident · No injuriesLimited investigationFinal reportRyan ST3KR (PT-22) · Hondo, TXThe plt was on a x-country flt. Near the destination the eng experienced sudden seizure and all eng pwr was lost. The plt attempted an emergency landing but collided with a pwr line which resulted in substantial damage to the acft. The cause of the loss of…NTSB FTW77FA054Accident · 1 fatalClosedRyan ST-3KR · San Angelo, TXNTSB FTW75DRA09Accident · Serious injuriesClosedRyan ST3KR · Friendswood, TXNTSB FTW72DRG33Accident · Minor injuriesClosedRyan ST-3KR · Georgetown, TXNTSB FTW66D0006Accident · No injuriesClosedBrewster FLEET2 · Sonora, TXNTSB UNK64X1783Accident · Minor injuriesClosedRyan ST3KR · Angleton, TX