Skip to content

NTSB investigations: Naval Aircraft Factory N3N-3, CA

28 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" = '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 ('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\" = '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 ('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" = '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 ('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 WPR09LA025Accident · No injuriesLimited investigationFinal reportNaval Aircraft Factory N3N-3 · Rialto, CAA total loss of engine power during initial climb due to an interruption in fuel flow through an improperly assembled carburetor.Oct 26, 2008 · N44848 · Substantial damage NTSB LAX90DVA03Accident · Serious injuriesFinal reportNaval Aircraft Factory N3N-3 · Madera, CAThe pilot inadvertently descending into the ground. Contributing to the accident was the inflight opening of the hopper lid which partially obscured the pilot's vision.May 5, 1990 · N45184 · Destroyed NTSB LAX83LVG16Accident · Serious injuriesFinal reportNaval Aircraft Factory N3N-3-2939 · Lincoln, CAThe pilot was performing touch and go landings to runway 15 and 33 at Lincoln municipal airport. Witnesses observed the pilot make a steep climb following a touch and go landing to runway 15. The aircraft crashed on the airport property.Aug 5, 1983 · N87697 · No damage NTSB LAX78DUM29Accident · Serious injuriesClosedNaval Fcty N3N-3 · Brawley, CAJun 29, 1978 · N45234 · Destroyed NTSB OAK78FVG18Accident · No injuriesClosedNavy N3N · Davis, CAFeb 3, 1978 · N44926 · Substantial damage NTSB LAX77FUM27Accident · No injuriesClosedNaval Fcty N3N-3 · Brawley, CAApr 14, 1977 · N44875 · Destroyed NTSB OAK76DVG55Accident · No injuriesClosedNaval Fcty N3N-3 · Winters, CAMar 16, 1976 · N52568 · Substantial damage NTSB LAX76DUG36Accident · Serious injuriesClosedNaval Fcty N3N · Ripley, CAFeb 18, 1976 · N44846 · Destroyed NTSB OAK75DVD08Accident · No injuriesClosedNaval Fcty N3N-3 · Tracy, CAAug 29, 1974 · N44736 · Substantial damage NTSB LAX75FUG01Accident · Minor injuriesClosedNaval Fcty N3N-3 · Lucerne, CAJul 21, 1974 · N44760 · Substantial damage NTSB OAK73FVG71Accident · No injuriesClosedNaval Fcty N3N-1 · Davis, CAJun 29, 1973 · N7752C · Substantial damage NTSB OAK73DVG60Accident · No injuriesClosedNaval Fcty N3N · Nelson, CAApr 24, 1973 · N45307 · Substantial damage NTSB LAX73FUQ27Accident · No injuriesClosedNaval Fcty N3N-3 · Acton, CAMar 30, 1973 · N9611 · Substantial damage NTSB LAX73FUM07Accident · Serious injuriesClosedNaval Fcty N3N-3 · Winterhaven, CAOct 21, 1972 · N44951 · Destroyed NTSB OAK72DVD42Accident · No injuriesClosedNaval Fcty N3N · Lodi, CAApr 17, 1972 · N44736 · Substantial damage NTSB OAK71FVG70Accident · No injuriesClosedNVL Fcty N3N-3 · Orland, CAApr 5, 1971 · N45307 · Substantial damage NTSB OAK71FVG15Accident · Serious injuriesClosedNaval Fcty N3N · Winters, CAAug 31, 1970 · N45125 · Destroyed NTSB OAK70FVD20Accident · Minor injuriesClosedNaval Fcty N3N-3 · Lodi, CAMay 14, 1970 · N44736 · Substantial damage NTSB LAX69F0084Accident · No injuriesClosedNaval Fcty N3N-1 · Calipatria, CAAug 14, 1968 · N44922 · Substantial damage NTSB LAX68D0396Accident · Serious injuriesClosedNaval Fcty N3N-3 · Brawley, CAApr 26, 1968 · N44861 · Destroyed NTSB OAK68F0345Accident · Serious injuriesClosedNaval Fcty N3N-3 · Oakley, CAMar 28, 1968 · N45011 · Destroyed NTSB OAK68D0110Accident · Serious injuriesClosedNaval Fcty N3N · Dos Palos, CAAug 26, 1967 · N44841 · Substantial damage NTSB OAK68D0277Accident · Minor injuriesClosedNaval Fcty N3N-1 · Dunnigan, CAAug 14, 1967 · N52568 · Destroyed NTSB LAX67D0142Accident · No injuriesClosedNaval Fcty N3N-3 · Imperial, CASep 19, 1966 · N44964 · Substantial damage NTSB LAX66F0116Accident · No injuriesClosedNaval Arcft N3N · Calipatria, CASep 19, 1965 · N44967 · Destroyed NTSB LAX66F0041Accident · Minor injuriesClosedNaval Arcft N3N · Brawley, CAAug 3, 1965 · N44986 · Substantial damage NTSB UNK65X0572Accident · No injuriesClosedNavy N3N · Imperial, CANov 5, 1964 · N45234 · Destroyed NTSB UNK64X2268Accident · No injuriesClosedUS Navy N3N1 · Dixon, CAJun 13, 1964 · N45213 · No damage