NTSB investigations: Navion NAVION G, CA

9 cases on aircraft the registry lists as Navion NAVION G. 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: Navion NAVION G, CA per year, 1964–2026: 9 cases
1964	1
1965	1
1969	1
1970	1
1973	2
1992	1
2005	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 ('6150120')) 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 ('6150120'))
  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 ('6150120'))
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 SEA07LA048Accident · Serious injuriesLimited investigationFinal reportNavion G Model · El Centro, CAThe loss of engine power for undetermined reasons. Contributing factors were the lack of suitable terrain for the forced landing and the glare from the sun.Jan 15, 2007 · N3BP · Substantial damage NTSB LAX06FA049Accident · 1 fatalField investigationFinal reportNavion G · Imperial, CAThe pilot's failure to maintain clearance from a tree and transmission wires while performing a low altitude maneuver. Also causal was the pilot's impaired judgment and performance due to alcohol ingestion.Nov 29, 2005 · N2455T · Destroyed NTSB LAX92LA181Accident · No injuriesLimited investigationFinal reportNavion G · Santa Paula, CAThe pilot's improper aircraft preflight by failing to assure the fuel selector handle was in the proper position. Factors relating to this accident was the engine fuel starvation.Apr 21, 1992 · N2489T · Substantial damage NTSB OAK74FVD05Accident · No injuriesClosedNavion G · Lodi, CAAug 25, 1973 · N2414T · Destroyed NTSB OAK73AP028Accident · 3 fatalClosedNavion G · Woodside, CAMar 21, 1973 · N2366T · Destroyed NTSB OAK70DVW06Accident · No injuriesClosedNavion G · Lone Pine, CAMar 19, 1970 · N2459T · Substantial damage NTSB LAX70D0137Accident · No injuriesClosedNavion G · Chino, CASep 13, 1969 · N2420T · Substantial damage NTSB OAK66D0141Accident · Serious injuriesClosedNavion G · Gustine, CAOct 29, 1965 · N2427T · Substantial damage NTSB UNK64X2443Accident · No injuriesClosedNavion G1 · Needles, CAJun 23, 1964 · N2459T · Substantial damage