NTSB investigations: Ryan NAVION, CA
17 cases on aircraft the registry lists as Ryan NAVION. 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 | 3 |
|---|---|
| 1965 | 2 |
| 1968 | 2 |
| 1969 | 1 |
| 1972 | 1 |
| 1974 | 1 |
| 1980 | 1 |
| 1984 | 1 |
| 1988 | 1 |
| 1997 | 1 |
| 2005 | 1 |
| 2011 | 1 |
| 2014 | 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\" = '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 ('6150160'))
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 ('6150160'))
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 WPR14LA337Accident · No injuriesLimited investigationFinal reportRyan Navion · Fresno, CAA partial loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR12LA070Accident · Serious injuriesLimited investigationFinal reportRyan Navion · Concord, CAThe pilot's inadequate preflight inspection of the airplane and the subsequent total loss of engine power as a result of debris and water contamination in the fuel system.NTSB LAX06CA062Accident · No injuriesData collectionFinal reportRyan Navion · Los Angeles, CAthe pilot's failure to maintain adequate clearance from a parked vehicle.NTSB LAX97LA115Accident · No injuriesLimited investigationFinal reportRyan Navion · Marina, CAFuel exhaustion due to the pilot's improper preflight inspection and his inaccurate fuel consumption calculations.NTSB LAX88LA243Accident · Minor injuriesLimited investigationFinal reportRyan Navion · Lancaster, CANTSB LAX84LA491Accident · No injuriesLimited investigationFinal reportRyan-Navion NAV-4-1908 · Milpitas, CAThe acft made a forced landing immediately after takeoff when the engine quit at about 220 ft AGL. The acft was landed in a garbage dump. Post accident investigation revealed no discrepancies in the acft to account for the engine stoppage. The reported…NTSB LAX80DUG22Accident · Minor injuriesClosedRyan Navion · Wrightwood, CANTSB OAK74AP043Accident · 3 fatalClosedRyan Navion · Columbia, CANTSB OAK72FVG46Accident · Serious injuriesClosedNavion A · Jackson, CANTSB OAK72AP007Accident · 2 fatalClosedNavion B · Etna, CANTSB OAK69D0246Accident · No injuriesClosedNavion A · Davis, CANTSB LAX68D0344Accident · No injuriesClosedNavion G · Baker, CANTSB OAK65A0067Accident · 3 fatalClosedN American Navion · 2ne Colfax, CANTSB LAX65D0032Accident · No injuriesClosedNavion A · San Diego, CANTSB UNK64X3432Accident · No injuriesClosedNavion B · Thermol, CANTSB UNK64X3014Accident · No injuriesClosedNavion · Elk Grove, CANTSB UNK64X1432Accident · No injuriesClosedNavion L17B · Clear Lakes, CA