NTSB investigations: Ryan NAVION A, CA

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

NTSB investigations: Ryan NAVION A, CA per year, 1964–2026: 12 cases
1964	4
1966	1
1969	1
1970	1
1972	1
1973	1
1983	1
1990	1
2007	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."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('6150162')) 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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('6150162'))
  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" = 'CA' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('6150162'))
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 LAX07LA118Accident · 2 fatalLimited investigationFinal reportRyan Navion A · Los Banos, CAthe pilot's intentional performance of aerobatic maneuvers that exceeded the design stress limits of the airplane structure. Also causal was the pilot's impairment due to the effects of alcohol consumption. Contributory was the pilot's impairment due to the…Mar 30, 2007 · N4369K · Destroyed NTSB LAX90LA306Accident · Serious injuriesLimited investigationFinal reportRyan Navion · San Diego, CAFuel starvation caused by blockage of fuel inlet screen by piece of improperly installed fuel hose.Aug 27, 1990 · N4220K · Substantial damage NTSB LAX83FA141Accident · 2 fatalField investigationFinal reportRyan Navion A · Fiddletown, CAThe acft crashed into hilly terrain while descending to enter the traffic pattern at the rancho murieta airport. The pilot had called sacramento fss to get assistance in locating this arpt which is about 11 NM from sacramento VOR on a bearing of about 65…Mar 12, 1983 · N444N · Destroyed NTSB OAK74AP027Accident · 4 fatalClosedNavion A · Firebaugh, CADec 31, 1973 · N4582K · Destroyed NTSB OAK73FVA31Accident · Minor injuriesClosedNavion L-17A · Atwater, CADec 3, 1972 · N5419V · Destroyed NTSB OAK71FVG24Accident · Serious injuriesClosedNavion A · Montague, CASep 22, 1970 · N484S · Destroyed NTSB LAX70F0233Accident · Serious injuriesClosedRyan NAV-A · Santa Ana, CANov 25, 1969 · N4212K · Substantial damage NTSB OAK67D0232Accident · No injuriesClosedNavion D · Santa Cruz, CAJun 4, 1966 · N5419V · Substantial damage NTSB UNK64X2579Accident · No injuriesClosedNavion B · Brawley, CAJun 30, 1964 · N4024K · Substantial damage NTSB UNK64X2393Accident · No injuriesClosedRyan L17B · Columbia, CAJun 20, 1964 · N7729C · Destroyed NTSB UNK64X2033Accident · No injuriesClosedNavion NAV4 · Placentia, CAMay 30, 1964 · N4582K · Substantial damage NTSB UNK64X0836Accident · No injuriesClosedNavion NAV4 · Concord, CAMar 7, 1964 · N4305K · Substantial damage