NTSB investigations: North American SNJ-5, CA
12 cases on aircraft the registry lists as North American SNJ-5. 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
| 1967 | 1 |
|---|---|
| 1971 | 1 |
| 1977 | 2 |
| 1980 | 1 |
| 1982 | 1 |
| 1989 | 1 |
| 1993 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 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.\"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 ('6400418', '6400429'))
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 ('6400418', '6400429'))
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 GAA19CA207Accident · No injuriesData collectionFinal reportNorth American SNJ · Chino, CAThe other pilot's failure to maintain clearance from a stopped airplane while taxiing.NTSB WPR19LA014Accident · No injuriesClass 3 · LimitedFinal reportNorth American SNJ · Agoura Hills, CAThe failure of the No. 5 piston rod end due to fatigue, which resulted in a total loss of engine power.NTSB GAA17CA242Accident · No injuriesData collectionFinal reportNorth American SNJ · Van Nuys, CAThe pilot’s failure to maintain directional control of the airplane during the landing roll with a quartering tailwind.NTSB GAA16CA464Accident · No injuriesData collectionFinal reportNorth American SNJ · Perris, CAThe pilot's inability to compensate for a dust devil during an aborted landing, which resulted in the left wing contacting the ground, a runway excursion, and the airplane coming to rest in a nose-down attitude.NTSB LAX94LA063Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Santa Paula, CAwas the failure of the needle valve pin assembly in the airplane's carburetor. A factor which contributed to the accident was the lack of suitable terrain for the emergency landing.NTSB LAX90LA004Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Pacoima, CAThe pilot's misjudgement of the proper altitude and distance from the runway during a night approach.NTSB LAX82DA358Accident · No injuriesFinal reportNorth American SNJ-6 · Santa Rosa, CAEngine quit at 500 feet AGL after takeoff. Pilot turned back but overshot field.NTSB LAX80DUA17Accident · No injuriesClosedN American SNJ-5 · Long Beach, CANTSB LAX78FUQ05Accident · No injuriesClosedN American SNJ-5 · Van Nuys, CANTSB OAK77FA036Accident · 1 fatalClosedN.American SNJ-5 · Petaluma, CANTSB LAX71FUA39Accident · No injuriesClosedN.American SNJ-5 · Long Beach, CANTSB LAX69D0095Accident · No injuriesClosedN.American AT-6 · Lancaster, CA