Skip to content

Fatal NTSB investigations: Ryan NAVION A

20 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

19652026

Where

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 ('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.\"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 ('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."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 ('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 ERA17FA052Accident · 1 fatalField investigationFinal reportRyan Navion · New Gretna, NJThe pilot's inadequate preflight weather planning and in-flight weather evaluation, which resulted in an encounter with a strong cold front and the pilot's subsequent loss of airplane control.Nov 20, 2016 · N4976K · Substantial damage 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 NYC89FA029Accident · 3 fatalField investigationFinal reportRyan Navion A · Franklin, PADue to improper grade of fuel in the airplane and bent and binding exhaust valves, the airplane engine had a partial loss of power during the takeoff ground run. The pilot did not abort the takeoff and the airplane stalled and collided with trees when the…Nov 14, 1988 · N5164K · Destroyed NTSB BFO88FA031Accident · 2 fatalField investigationFinal reportRyan Navion NA-4 · Fancy Gap, VAThe pilot failed to maintain visual contact and clearance with rising terrain after VFR flight encountered IMC.Mar 25, 1988 · N1598V · Destroyed 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 FTW82FPJ10Accident · 1 fatalFinal reportNavion A · Chickasha, OKThe aircraft departed from a private airport 2 miles south of Chickasha at 0330. At 0336 power was interrupted on electric power lines southwest of Chickasha. The wreckage was found 6 miles south and 4 and 1/2 miles west of Chickasha a few feet west of a 35…Jan 2, 1982 · N4876K · Destroyed NTSB SEA77FA004Accident · 4 fatalClosedN.American Navion · Yakima, WAOct 23, 1977 · N91580 · Destroyed NTSB IAD74AI066Accident · 4 fatalClosedRyan Navion · High Falls, NCMay 18, 1974 · N4380K · Destroyed NTSB OAK74AP027Accident · 4 fatalClosedNavion A · Firebaugh, CADec 31, 1973 · N4582K · Destroyed NTSB MIA73AM103Accident · 2 fatalClosedNavion A · Missing AircraftMay 25, 1973 · N5126K · Destroyed NTSB MKC72AK024Accident · 2 fatalClosedNavion A · Macon, MOOct 2, 1971 · N4249K · Destroyed NTSB CHI70AC082Accident · 3 fatalClosedNavion A · Evansville, WIMay 23, 1970 · N5105K · Destroyed NTSB CHI70A0018Accident · 1 fatalClosedNavion A · Milwaukee, WISep 27, 1969 · N4393K · Destroyed NTSB FTW69A0016Accident · 4 fatalClosedNavion A · Alto, TXSep 4, 1968 · N142W · Destroyed NTSB NYC68A0122Accident · 4 fatalClosedNavion A · Greenwich, CTMay 26, 1968 · N4918K · Destroyed NTSB CHI68A0027Accident · 3 fatalClosedNavion A · Dansville, MISep 20, 1967 · N4894K · Destroyed NTSB SEA66A0033Accident · 2 fatalClosedNavion A · Lowman, IDNov 20, 1965 · N4203K · Destroyed NTSB CHI66A0037Accident · 2 fatalClosedNavion A · Spencer, INOct 17, 1965 · N4954K · Destroyed NTSB NYC66A0030Accident · 1 fatalClosedNavion A · St Marys, PASep 2, 1965 · N5115K · Destroyed NTSB CHI65A0092Accident · 3 fatalClosedNavion A · Peoria, ILApr 27, 1965 · N4506K · Destroyed