NTSB investigations: Ryan NAVION A, TX
8 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.
Cases per year
| 1964 | 1 |
|---|---|
| 1967 | 1 |
| 1968 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1990 | 1 |
| 2001 | 1 |
| 2023 | 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.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" = '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.aircraft_model_code IN ('6150162'))
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 CEN23LA153Accident · Minor injuriesClass 3 · LimitedFinal reportRyan Navion A · New Waverly, TXA total loss of engine power as a result of fuel contamination.NTSB FTW02LA053Accident · Serious injuriesLimited investigationFinal reportRyan Navion A · Sierra Blanca, TXthe pilot's inadverent VFR flight into instrument meteorological weather conditions which resulted in an in-flight collision with terrain. Contributing factors were the night light conditions and the clouds.NTSB FTW90LA104Accident · No injuriesLimited investigationFinal reportRyan Navion A · Denison, TXPilot's attempted takeoff with conditions in excess of the airplane's performance capabilities. Contributing to the accident was the high density altitude and the uphill runway.NTSB FTW83LA294Accident · No injuriesLimited investigationFinal reportRyan NAVION-A · Kenedy, TXAfter taking off, the eng began to lose power. The plt said it quit & restarted several times while he was trying to return to the arpt. During an emergency landing, about 3 mi from the arpt, the plt elected to land with the gear retracted since there were…NTSB FTW82DA116Accident · Minor injuriesFinal reportRyan Navion A · Center, TXThe aircraft landed short of the runway, hit an embankment and collapsed the landing gear. The pilot believes wind shear and turbulence were a factor in the downdraft off the end of the runway.NTSB FTW69A0016Accident · 4 fatalClosedNavion A · Alto, TXNTSB FTW68F0194Accident · No injuriesClosedNavion A · Euless, TXNTSB UNK64X0470Accident · No injuriesClosedNavion A · Harper, TX