Fatal NTSB investigations: Ryan NAVION B

12 cases on aircraft the registry lists as Ryan NAVION 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

19642026

Fatal NTSB investigations: Ryan NAVION B per year, 1964–2026: 12 cases
1964	2
1969	1
1971	1
1973	2
1974	1
1975	1
1981	1
1997	2
2018	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.aircraft_model_code IN ('6150170')) 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.aircraft_model_code IN ('6150170'))
  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.aircraft_model_code IN ('6150170'))
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 WPR18FA198Accident · 2 fatalField investigationFinal reportRyan Navion · Truckee, CAA loss of engine power for reasons that could not be determined.Jul 17, 2018 · N5329K · Substantial damage NTSB LAX97FA330Accident · 2 fatalField investigationFinal reportRyan Navion B · Pacoima, CAthe dual student's improper positioning of the fuel selector and the CFI's inadequate supervision, which led to a takeoff with the auxiliary fuel tank selected and resulted in fuel starvation. A contributing factor was the position of the nomenclature on the…Sep 26, 1997 · N5241K · Destroyed NTSB FTW97FA262Accident · 4 fatalField investigationFinal reportRyan Navion B · Garfield, COfailure of the pilot to maintain adequate airspeed, during a turn to reverse direction, which resulted in a stall and collision with a pole and a building. High density altiitude was a related factor.Jul 11, 1997 · N5401K · Destroyed NTSB LAX81FA129Accident · 1 fatalClosedRyan Navion · Firebaugh, CASep 22, 1981 · N5345K · Destroyed NTSB MIA76AM053Accident · 5 fatalClosedNavion B · Cross City, FLDec 20, 1975 · N5275K · Destroyed NTSB IAD74AI053Accident · 3 fatalClosedNavion B · Bowie, MDMar 17, 1974 · N5245K · Destroyed NTSB OAK74AP016Accident · 3 fatalClosedNavion B · Red Bluff, CAOct 6, 1973 · N5152K · Destroyed NTSB DEN73AD033Accident · 1 fatalClosedNavion B · La Veta, COJan 27, 1973 · N4024K · Destroyed NTSB NYC72AN047Accident · 2 fatalClosedNavion B · Hazleton, PAOct 4, 1971 · N5259K · Destroyed NTSB OAK70A0012Accident · 2 fatalClosedNavion B · Ash Meadows, NVAug 21, 1969 · N5255K · Destroyed NTSB UNK64X3832Accident · 2 fatalClosedRyan Navion · Suffield, CTSep 6, 1964 · N5346K · Destroyed NTSB UNK64X1303Accident · 1 fatalClosedNavion B · Altoona, PAApr 13, 1964 · N5234K · Destroyed