NTSB investigations: Navion NAVION A, CA
11 cases on aircraft the registry lists as Navion 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 |
|---|---|
| 1968 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1982 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 1995 | 1 |
| 1998 | 1 |
| 2012 | 1 |
| 2020 | 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 ('6150104'))
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 ('6150104'))
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 WPR21LA072Accident · No injuriesClass 3 · LimitedFinal reportNavion Navion A · Livermore, CAThe improper installation of the gascolator fuel inlet line and hose clamp connection, which resulted in the total loss of engine power.NTSB WPR12LA434Accident · No injuriesLimited investigationFinal reportNavion Navion · Lompoc, CAA total loss of engine power after takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB LAX98LA212Accident · No injuriesLimited investigationFinal reportNorth American Navion · San Andreas, CAThe pilot's improper reinstallation of the fuel selector valve handle, which led to the selection of the wrong fuel tank and fuel starvation.NTSB LAX95LA301Accident · Serious injuriesLimited investigationFinal reportNavion A · Groveland, CAfuel starvation, due to the pilot's improper positioning of the fuel selector. The lack of suitable terrain for a forced landing was a related factor.NTSB LAX90LA228Accident · No injuriesLimited investigationFinal reportNavion A · Big Bear, CAThe failure of the pilot to adequately compensate for the cross wind on his approach.NTSB LAX87FA291Accident · Minor injuriesField investigationFinal reportNavion A · Hawthorne, CADuring a pleasure cross country flt, the eng sputtered then regained full pwr. The plt turned toward a nearby arpt and was cleared to land. En route to the arpt the engine lost full power. When the pilot thought he could make the rwy he extended the landing…NTSB LAX82FUM06Accident · 3 fatalFinal reportNavion A · Ramona, CAThe accident occurred during the final leg of a "share the expenses" commuting flight from hawthorne to romona, CA, when the aircraft collided with the southwest face of mount woodson. Marginal VFR conditions prevailed over the route of flight. During the…NTSB OAK78DVA74Accident · Minor injuriesClosedNavion A · Chowchilla, CANTSB LAX77FUG18Accident · Minor injuriesClosedNavion A · Redlands, CANTSB LAX69A0036Accident · 2 fatalClosedNavion A · Tecate, CANTSB UNK64X2303Accident · No injuriesClosedNavion NAV4 · El Centro, CA