NTSB investigations: Navion NAVION A

7 cases on aircraft the registry lists as Navion NAVION A, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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

19842026

NTSB investigations: Navion NAVION A per year, 1984–2026: 7 cases
1984	1
1987	2
1991	1
1995	1
1998	1
2000	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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('6150104') AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 353)) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('6150104')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 353))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('6150104')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 353))
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 NYC01LA032Accident · Serious injuriesLimited investigationFinal reportNavion A · Lumberton, NJThe pilot's misjudgment of altitude and distance to the runway while performing a forced landing after an engine failure. Factors related to the accident were the pilot's inadequate rebuilding procedures and maintenance inspection, which resulted in…Nov 8, 2000 · N675JM · Substantial damage 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.Jun 26, 1998 · N1400Z · Substantial damage 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.Aug 22, 1995 · N8513H · Substantial damage NTSB CHI91LA185Accident · Serious injuriesLimited investigationFinal reportRyan Navion A · Kankakee, ILThe pilot's poor in flight planning/decision making and misjudged fuel supply. A related factor is the inadequate emergency procedure.Jun 8, 1991 · N4374K · Substantial damage 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…Aug 4, 1987 · N4388K · Substantial damage NTSB CHI87DEM06Accident · Serious injuriesFinal reportNavion A · Baldwin, MIAfter beginning a level off at aprx 6000 ft, the acft engine stopped. During the forced landing the acft crashed in a heavily wooded area aprx 1/2 mile west of the arpt. An examination of the wreckage revealed that both wing tanks were empty and the…Apr 19, 1987 · N4961C · Substantial damage NTSB SEA84LA056Accident · No injuriesLimited investigationFinal reportNavion A · Albany, ORThe acft crashed into a tree and a fence during a forced landing following engine stoppage during the initial climb after takeoff. Investigation revealed that the acft had only one cup of fuel mixed with water and rust in the tank beingused. The right tip…Feb 18, 1984 · N91123 · Substantial damage