Skip to content

NTSB investigations: North American SNJ-4

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

19652026

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('6400414')) 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 ('6400414'))
  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 ('6400414'))
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 WPR20LA025Accident · No injuriesClass 3 · LimitedFinal reportNorth American SNJ-4 · Heber City, UTThe pilot’s loss of directional control during landing as a result of the separated tailwheel-to-rudder link rodNov 16, 2019 · N694US · Substantial damage NTSB CEN17LA323Accident · Serious injuriesLimited investigationFinal reportNorth American SNJ-4 · Ashland, OHThe pilot’s improper recovery from a bounced landing, which resulted in a loss of directional control.Aug 12, 2017 · N243CC · Substantial damage NTSB ERA10CA329Accident · No injuriesData collectionFinal reportNorth American SNJ-4 · Suffolk, VAThe pilot's failure to maintain directional control during the landing.Jun 17, 2010 · N43NA · Substantial damage NTSB DEN99LA155Accident · Minor injuriesLimited investigationFinal reportNorth American SNJ-4 (AT-6) · Mack, COThe pilot misjudging his distance and altitude from the runway. A factor was the tall crops.Aug 28, 1999 · N7011C · Substantial damage NTSB LAX94LA368Accident · 1 fatalLimited investigationFinal reportNorth American SNJ-5 · Reno, NVthat the pilot of the other airplane misjudged the distance between the airplanes. The other airplane pilot's diverted attention to the air race is a factor in this accident.Sep 18, 1994 · N8540Z · 2 aircraft · Destroyed NTSB DEN87LA222Accident · No injuriesLimited investigationFinal reportNorth American AT-6C · Colorado Spring, COThe plt reports that he accepted a tailwind for his landing and ground-looped during the roll out.Aug 15, 1987 · N7058C · Substantial damage NTSB DCA87MA029Accident · 4 fatalClass 1 · MajorFinal reportCessna 340A · Orlando, FLThe two acft, a Cessna 340A and a north American SNJ-4, collided in flt at aprx 3000 ft MSL over Orlando FL in VMC with a visibility of 7 miles. Both acft were in contact with and being radar vectored by Orlando approach control. The C-340 was in level flt…May 1, 1987 · N8716K · 2 aircraft · Destroyed NTSB LAX85IA396Incident · No injuriesIncident investigationFinal reportNorth American SNJ-4 · Reno, NVThe pilot experienced a 'severe vibration' and made an emergency landing during a heat race at the national championship air races. Subsequent examination revealed that a propeller blade pitch change bolt, p/n 53546, had failed, allowing one propeller blade…Sep 12, 1985 · N86WW · Minor damage NTSB OAK78DA055Accident · 2 fatalClosedN.American SNJ-4 · Reno, NVSep 16, 1978 · N7038C · 2 aircraft · Destroyed NTSB MKC78FA051Accident · 1 fatalClosedN American SNJ-4 · Gravois Mills, MOJun 25, 1978 · N9589C · Destroyed NTSB LAX78FUG23Accident · Minor injuriesClosedN American SNJ-4 · Rialto, CAApr 23, 1978 · N7077C · Substantial damage NTSB DEN76DTE78Accident · Minor injuriesClosedN. American SNJ-4 · Trinidad, COJul 2, 1976 · N7406C · Substantial damage NTSB IAD74FLJ06Accident · 1 fatalClosedN.American AT-6C · Clarkton, NCJul 29, 1973 · N6419D · Substantial damage NTSB NYC74FFA01Accident · Minor injuriesClosedN.American SNJ-4 · East Chatham, NYJul 2, 1973 · N7008C · Substantial damage NTSB MKC73AK003Accident · 2 fatalClosedN.American SNJ-4 · Thief Rvr Fl, MNJul 6, 1972 · N7056C · Destroyed NTSB MKC72FCA16Accident · No injuriesClosedN.American SNJ-4 · Chesterfield, MONov 16, 1971 · N1395N · Substantial damage NTSB NYC72FID12Accident · No injuriesClosedN.American SNJ-4 · Fredericksburg, VASep 4, 1971 · N6414D · Substantial damage NTSB FTW71DPD48Accident · No injuriesClosedN American SNJ-4 · Brownwood, TXMar 11, 1971 · N7406C · Substantial damage NTSB NYC71AN008Accident · 1 fatalClosedN American SNJ-4 · Billings, NYJul 18, 1970 · N733L · Destroyed NTSB CHI70FBD36Accident · Serious injuriesClosedN.American SNJ-4 · Addison, ILMay 23, 1970 · N173V · Destroyed NTSB MIA70DKJ22Accident · No injuriesClosedN American SNJ-4 · Dothan, ALApr 12, 1970 · N6411D · Substantial damage NTSB DIA69F0019Accident · No injuriesClosedN.American SNJ4 · Frederick, MDJul 7, 1968 · N4140A · Substantial damage NTSB CHI68F0158Accident · No injuriesClosedN.American SNJ-4 · Frankfort, ILJun 25, 1967 · N173V · Substantial damage NTSB OAK67D0297Accident · No injuriesClosedN.American AT-6 · Las Vegas, NVApr 11, 1967 · N7034C · Substantial damage NTSB LAX66D0059Accident · No injuriesClosedNo American AT-6C · San Diego, CAJul 27, 1965 · N7062C · Substantial damage