Skip to content

NTSB investigations: Naval Aircraft Factory N3N-3, AZ

31 cases on aircraft the registry lists as Naval Aircraft Factory N3N-3. 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" = 'AZ' 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 ('6120202')) 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\" = 'AZ' 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 ('6120202'))
  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" = 'AZ' 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 ('6120202'))
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 LAX98LA207Accident · Serious injuriesLimited investigationFinal reportNaval Aircraft Factory N3N-3 · Skull Valley, AZThe pilot's failure to maintain control of the aircraft while maneuvering at a low altitude.Jun 20, 1998 · N45053 · Destroyed NTSB LAX96LA153Accident · No injuriesLimited investigationFinal reportNaval Aircraft Factory N3N-3 · Chandler, AZThe failure of both the engine driven and hand wobble fuel pumps, which resulted in fuel starvation to the engine.Apr 3, 1996 · N45043 · Substantial damage NTSB LAX89LA134Accident · No injuriesLimited investigationFinal reportNaval Aircraft Factory N3N-3 · Phoenix, AZLoss of control due to inadequate preflight and control interference.Mar 24, 1989 · N60KB · Substantial damage NTSB LAX76DUJ01Accident · No injuriesClosedNaval Fcty N3N-3 · Tempe, AZAug 12, 1976 · N44744 · Substantial damage NTSB LAX76FUJ97Accident · No injuriesClosedNaval Fcty N3N-3 · Coolidge, AZAug 5, 1976 · N44738 · Substantial damage NTSB LAX76DUJ13Accident · Minor injuriesClosedNaval Fcty N3N-1 · Mesa, AZAug 16, 1975 · N44756 · Destroyed NTSB LAX75DUJ19Accident · No injuriesClosedNaval Fcty N3N-1 · Queen Creek, AZAug 9, 1974 · N45184 · Substantial damage NTSB LAX72DUJ46Accident · No injuriesClosedNaval Fcty N3N-1 · Gadsden, AZSep 14, 1971 · N45065 · Substantial damage NTSB LAX72FUJ39Accident · No injuriesClosedNaval Fcty N3N-3 · Phoenix, AZSep 4, 1971 · N45117 · Substantial damage NTSB LAX72FUJ30Accident · No injuriesClosedNaval Fcty N3N-3 · Phoenix, AZAug 17, 1971 · N9611 · Substantial damage NTSB LAX72DUJ23Accident · No injuriesClosedNaval Fcty N3N-3 · Stanfield, AZAug 11, 1971 · N44713 · No damage NTSB LAX71FUJ98Accident · No injuriesClosedNaval Fcty N3N-3 · Stanfield, AZJun 2, 1971 · N45070 · Substantial damage NTSB LAX71DUJ36Accident · No injuriesClosedNaval Fcty N3N · Queen Creek, AZSep 11, 1970 · N9831Z · Substantial damage NTSB LAX70D0223Accident · No injuriesClosedNaval Fcty N3N-3 · Yuma, AZNov 4, 1969 · N45027 · Substantial damage NTSB LAX70F0071Accident · No injuriesClosedNaval Fcty N3N-1 · Litchfld Pk, AZAug 21, 1969 · N45280 · Destroyed NTSB LAX70F0105Accident · Minor injuriesClosedNaval 6fty N3N-1 · Tempe, AZAug 19, 1969 · N45117 · Substantial damage NTSB LAX70D0131Accident · No injuriesClosedNaval Fcty N3N-3 · Somerton, AZAug 19, 1969 · N44936 · Substantial damage NTSB LAX69D0070Accident · Minor injuriesClosedNaval Fcty N3N · Yuma, AZJul 14, 1968 · N44701 · Substantial damage NTSB LAX68D0354Accident · No injuriesClosedNaval Fcty N3N-3 · Yuma, AZMar 3, 1968 · N44846 · Substantial damage NTSB LAX68F0129Accident · 1 fatalClosedNaval Fcty N3N · Casa Grande, AZSep 9, 1967 · N45293 · Destroyed NTSB LAX68D0065Accident · No injuriesClosedNaval Fcty N3N · Chandler, AZJul 27, 1967 · N45151 · Substantial damage NTSB LAX68D0095Accident · No injuriesClosedNaval Fcty N3N · Chandler, AZJul 21, 1967 · N44814 · Substantial damage NTSB LAX68D0030Accident · Minor injuriesClosedNaval Fcty N3N · Casa Grande, AZJun 25, 1967 · N9841Z · Substantial damage NTSB LAX67D0330Accident · Minor injuriesClosedNavy N3N · Mesa, AZMar 5, 1967 · N44981 · Substantial damage NTSB DEN66F0174Accident · Minor injuriesClosedNaval Arcft N3N-3 · Sun City, AZNov 4, 1965 · N44757 · Substantial damage NTSB DEN66F0140Accident · No injuriesClosedNaval Arcft N3N-3 · Litchfield Pk, AZOct 25, 1965 · N45024 · Substantial damage NTSB DEN66D0128Accident · No injuriesClosedNaval Arcft N3N · Mesa, AZSep 11, 1965 · N44863 · Destroyed NTSB DEN66F0092Accident · Minor injuriesClosedNaval Arcft N3N-3 · Casa Grande, AZAug 6, 1965 · N45094 · Destroyed NTSB UNK64X3746Accident · No injuriesClosedNavy N3N3 · Gilbert, AZSep 2, 1964 · N45273 · Substantial damage NTSB UNK64X2084Accident · No injuriesClosedNavy N3N · Gilbert, AZJun 3, 1964 · N45217 · Substantial damage NTSB UNK64X1956Accident · Minor injuriesClosedNavy N3N3 · Sun Sites, AZMay 25, 1964 · N44837 · Substantial damage