NTSB investigations: North American SNJ-2
12 cases on aircraft the registry lists as North American SNJ-2. 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.
Cases per year
| 1964 | 1 |
|---|---|
| 1973 | 1 |
| 1974 | 1 |
| 1979 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1987 | 1 |
| 1993 | 1 |
| 2007 | 2 |
| 2018 | 1 |
| 2021 | 1 |
Where
Open the mapLatest cases
Query with SQL
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 ('6400404'))
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 ('6400404'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 ERA21FA334Accident · 1 fatalClass 3 · FieldFinal reportNorth American SNJ-2 · Wilkes-Barre, PAA partial loss of engine power for undetermined reasons. Also causal was the pilot’s exceedance of the airplane’s critical angle of attack while maneuvering for a forced landing following the loss of engine power, which resulted in an aerodynamic stall and…NTSB WPR18FA155Accident · 1 fatalField investigationFinal reportNorth American SNJ 2 · Melville, NYThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall, spin, and subsequent impact with terrain.NTSB NYC07LA219Accident · 1 fatalLimited investigationFinal reportNorth American SNJ-2 · Virginia Beach, VAThe pilot's inability to maintain control of the airplane due to physiological incapacitation. Contributing to the accident was the failure of the Federal Aviation Administration to deny or restrict the pilot's medical certification, and the pilot's improper…NTSB NYC07LA209Accident · No injuriesLimited investigationFinal reportNorth American SNJ-2 · Farmingdale, NYThe number 5 airplane pilot's inadequate visual lookout.NTSB NYC94LA009Accident · 1 fatalLimited investigationFinal reportNorth American SNJ-2 · Skaneateles, NYThe pilot's inadequate preflight preparation which failed to adequately secure cargo, resulting control interference. A factor was the overgross weight condition of the airplane.NTSB NYC87LA155Accident · No injuriesLimited investigationFinal reportNorth American SNJ-2 · Farmingdale, NYThe plt was performing touch-&-go landings. On the 3rd landing, the main gear collapsed & the acft received substantial damage. No pre-acdnt part failure or malfunction was reported.NTSB LAX84LA009Accident · No injuriesLimited investigationFinal reportNorth American SNJ-2 · Fresno, CAA flt of 5 North American SNJ-2 acft were on a flt from long beach to Fresno, CA. By prior arrangement, the lead plt in N61563 was to handle the radio communication with ATC facilities. During arrival at Fresno, the local controller inquired whether the group…NTSB NYC82DA078Accident · No injuriesFinal reportNorth American SNJ-2 · Flushing, NYThe flight proceeded without incident until the tail wheel was unlocked during the landing roll. The aircraft drifted to the left and struck a parked cherokee. Both aircraft were substantially damaged. Inspection revealed that residue of a recent paint…NTSB NYC79FA053Accident · No injuriesClosedPiper PA-23 · Flushing, NYNTSB NYC75FHJ10Accident · No injuriesClosedN.American SNJ-2 · Flushing, NYNTSB NYC74FHJ05Accident · Serious injuriesClosedN.American SNJ-2 · Flushing, NYNTSB UNK64X1183Accident · No injuriesClosedNo American SNJ2 · Flushing Bay, NY