Skip to content

NTSB investigations: North American NAVION, CA

34 cases on aircraft the registry lists as North American 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

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."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 ('6150130', '6150137')) 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 ('6150130', '6150137'))
  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 ('6150130', '6150137'))
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 WPR18LA049Accident · Serious injuriesLimited investigationFinal reportNorth American Navion · El Cajon, CAA total loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.Dec 17, 2017 · N8884H · Substantial damage NTSB LAX05LA303Accident · Minor injuriesLimited investigationFinal reportNorth American Navion A · Chowchilla, CAthe loss of engine power for undetermined reasons.Sep 19, 2005 · N91597 · Substantial damage NTSB LAX01FA112Accident · 1 fatalField investigationFinal reportNorth American Navion · Santa Ysabel, CAthe pilot's continued VFR flight into IFR conditions, which resulted in a loss of control due to spatial disorientation.Mar 9, 2001 · N91445 · Destroyed NTSB LAX98FA264Accident · 2 fatalField investigationFinal reportNorth American Navion · Salinas, CAthe pilot's attempt to continue visual flight operations into an area of known instrument meteorological conditions resulting in controlled flight into rising terrain.Aug 15, 1998 · N8820H · Destroyed NTSB LAX90LA071Accident · No injuriesLimited investigationFinal reportNorth American Navion · Apple Valley, CAThe pilot failed to properly preflight the airplane and departed on the accident flight with minimal fuel.Jan 20, 1990 · N727G · Substantial damage NTSB LAX86LA254Accident · No injuriesLimited investigationFinal reportNorth American Navion A · San Jose, CAThe acft's engine failed aprx 10 minutes after takeoff. The acft collided with a utility pole during the forced landing that followed. Post accident inpsection of the acft revealed the fuel selector was positioned on the aux tank. The main fuel tanks were…Jun 16, 1986 · N91608 · Substantial damage NTSB LAX79FA001Accident · 1 fatalClosedNavion A · Buena Park, CAOct 1, 1978 · N91160 · Substantial damage NTSB LAX78FUG35Accident · No injuriesClosedNavion NAV A · Apple Valley, CAJun 19, 1978 · N8782H · Substantial damage NTSB OAK7LFXQ10Accident · Minor injuriesClosedNavion A · Truckee, CAAug 26, 1975 · N8564H · Substantial damage NTSB LAX74AL088Accident · 4 fatalClosedNavion A-1 · Pismo Beach, CAJun 29, 1974 · N8918H · Destroyed NTSB OAK74AVA61Accident · No injuriesClosedNavion A · Patterson, CAApr 28, 1974 · N8929H · Substantial damage NTSB OAK72DVD50Accident · No injuriesClosedNavion A · Tracy, CAMay 18, 1972 · N91559 · Substantial damage NTSB LAX71AL073Accident · 2 fatalClosedNavion A · Calimesa, CAJun 9, 1971 · N91514 · Destroyed NTSB OAK71AP020Accident · 3 fatalClosedNavion G · Indepence, CAOct 23, 1970 · N8836H · Destroyed NTSB OAK70AP039Accident · 2 fatalClosedNavion A · Kelseyville, CAJan 26, 1970 · N91479 · Destroyed NTSB OAK69D0320Accident · No injuriesClosedNavion B · Bishop, CAMay 23, 1969 · N5140 · Substantial damage NTSB LAX69F0234Accident · No injuriesClosedNavion A · Fullerton, CAJan 29, 1969 · N91137 · Substantial damage NTSB LAX69F0240Accident · Serious injuriesClosedNavion A · Long Beach, CADec 16, 1968 · N91493 · Substantial damage NTSB OAK69D0133Accident · No injuriesClosedNavion B · Antioch, CASep 3, 1968 · N4021K · Substantial damage NTSB LAX68A0105Accident · 2 fatalClosedNavion A · Yucaipa, CAJun 15, 1968 · N91150 · Destroyed NTSB LAX68D0402Accident · No injuriesClosedNavion A · Palm Sprngs, CAMay 4, 1968 · N8929H · Substantial damage NTSB LAX68D0146Accident · No injuriesClosedNavion A · Bakersfield, CASep 13, 1967 · N91668 · Substantial damage NTSB LAX67D0420Accident · No injuriesClosedNavion A · Burbank, CAMay 6, 1967 · N8929H · Substantial damage NTSB LAX67A0097Accident · 4 fatalClosedNavion F · Alberhill, CAApr 16, 1967 · N91734 · Destroyed NTSB OAK67A0066Accident · 2 fatalClosedNavion NAV-A · S.Francisco, CAMar 6, 1967 · N8760H · Destroyed NTSB OAK67F0142Accident · Minor injuriesClosedNavion A · Morgan Hill, CASep 24, 1966 · N91537 · Substantial damage NTSB LAX67D0104Accident · No injuriesClosedNavion B · Bakersfield, CAAug 12, 1966 · N91668 · Substantial damage NTSB LAX66D0381Accident · No injuriesClosedNavion A · Imperial, CAJun 5, 1966 · N91440 · Substantial damage NTSB LAX66D0344Accident · No injuriesClosedNavion B · Apple Valley, CAMar 27, 1966 · N91132 · Substantial damage NTSB LAX66D0113Accident · No injuriesClosedNavion B · Lone Pine, CAApr 24, 1965 · N91445 · Substantial damage NTSB OAK65F0077Accident · No injuriesClosedNavion L-17A · Palo Alto, CAApr 12, 1965 · N8562H · Substantial damage NTSB LAX65D0081Accident · No injuriesClosedNavion B · Palm Springs, CAMar 13, 1965 · N8760H · Substantial damage NTSB LAX65F0002Accident · No injuriesClosedNavion A · Thousand Oaks, CAJan 11, 1965 · N91163 · Substantial damage NTSB UNK64X1008Accident · 3 fatalClosedNavion A · Pala, CAMar 21, 1964 · N91451 · Destroyed