Skip to content

NTSB investigations: Naval Aircraft Factory N3N-3

89 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, newest first

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 ('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.\"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."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 LAX70D0223Accident · No injuriesClosedNaval Fcty N3N-3 · Yuma, AZNov 4, 1969 · N45027 · Substantial damage NTSB MIA70F0136Accident · Minor injuriesClosedNaval Fcty N3N-3 · Glen Allan, MSSep 6, 1969 · N45075 · 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 LAX69F0084Accident · No injuriesClosedNaval Fcty N3N-1 · Calipatria, CAAug 14, 1968 · N44922 · Substantial damage NTSB CHI69F0168Accident · No injuriesClosedNaval N3N · Galva, ILAug 2, 1968 · N45013 · Substantial damage NTSB LAX69D0070Accident · Minor injuriesClosedNaval Fcty N3N · Yuma, AZJul 14, 1968 · N44701 · 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 LAX68D0354Accident · No injuriesClosedNaval Fcty N3N-3 · Yuma, AZMar 3, 1968 · N44846 · Substantial damage NTSB FTW68D0332Accident · No injuriesClosedNaval Fcty N3N · Frederick, OKNov 11, 1967 · N44830 · Substantial damage NTSB LAX68F0129Accident · 1 fatalClosedNaval Fcty N3N · Casa Grande, AZSep 9, 1967 · N45293 · 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 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 DIA67A0009Accident · 1 fatalClosedNaval Fcty N3N-3 · Hopewell, VAFeb 11, 1967 · N4743C · Substantial damage NTSB LAX67D0142Accident · No injuriesClosedNaval Fcty N3N-3 · Imperial, CASep 19, 1966 · N44964 · Substantial damage NTSB SEA67F0114Accident · Minor injuriesClosedNaval Fcty N3N-3 · Wapato, WAAug 9, 1966 · N45178 · Destroyed NTSB DEN67F0064Accident · No injuriesClosedNaval Fcty N3N-3 · Eaton, COJul 21, 1966 · N45229 · Substantial damage NTSB NYC67F0120Accident · No injuriesClosedCessna 150 · Atlantic City, NJJul 3, 1966 · N2583J · 2 aircraft · Substantial damage NTSB DEN67D0030Accident · No injuriesClosedNavy N3N-3 · Elk Mountain, WYJun 26, 1966 · N45056 · Substantial damage NTSB SEA66A0065Accident · 1 fatalClosedNaval Fcty N3N-3 · Rome, ORJun 12, 1966 · N45267 · Destroyed 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 LAX66F0116Accident · No injuriesClosedNaval Arcft N3N · Calipatria, CASep 19, 1965 · N44967 · Destroyed 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 LAX66F0041Accident · Minor injuriesClosedNaval Arcft N3N · Brawley, CAAug 3, 1965 · N44986 · Substantial damage NTSB FTW66D0044Accident · Minor injuriesClosedNaval Arcft N3N-3 · Ferriday, FLMay 31, 1965 · N45037 · Substantial damage NTSB UNK65X0572Accident · No injuriesClosedNavy N3N · Imperial, CANov 5, 1964 · N45234 · Destroyed NTSB UNK64X4005Accident · No injuriesClosedNavy N3N · Chelan Falls, WASep 16, 1964 · N44920 · Substantial damage NTSB UNK64X3746Accident · No injuriesClosedNavy N3N3 · Gilbert, AZSep 2, 1964 · N45273 · Substantial damage NTSB UNK64X2268Accident · No injuriesClosedUS Navy N3N1 · Dixon, CAJun 13, 1964 · N45213 · No 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