NTSB investigations: Grumman American Avn. AA-5, NY
9 cases on aircraft the registry lists as Grumman American Avn. AA-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
| 1973 | 1 |
|---|---|
| 1975 | 1 |
| 1979 | 2 |
| 1981 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 2000 | 1 |
| 2010 | 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\" = 'NY' 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 ('3960104'))
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" = 'NY' 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 ('3960104'))
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 ERA10CA451Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-5 · Montauk, NYThe pilot's delay in aborting the landing, which resulted in a collision with a fence.NTSB NYC00FA225Accident · 1 fatalField investigationFinal reportGrumman American AA-5 · Cherry Valley, NYThe pilot's improper decision to continue the flight into deteriorating weather, which resulted in his failure to maintain control of the airplane. Factors in the accident were the dark night, fog, low ceiling, and the pilot's inadequate preflight planning.NTSB NYC85LA214Accident · No injuriesLimited investigationFinal reportGrumman American AA-5 · Montgomery, NYThe plt reported that the flt was uneventful until he was in a descent about 12 mi from the destination arpt. He said that a large bird suddenly appeared in front of the acft & collided with the right wing. The bird strike put a large hole in the right wing…NTSB NYC84FA233Accident · 1 fatalField investigationFinal reportGrumman AA-5 · Woodstock, NYAcft was on a VFR personal flight. Witness on mountain slope heard sounds of approaching acft, observed brief glimpse of acft wheel and wing through cloud and fog about 100 ft away, at tree-top level. A few seconds later. Witness heard eng sound cease.…NTSB NYC81FFJ13Accident · No injuriesClosedGrumman AA-5A · Batavia, NYNTSB NYC79FFA26Accident · Serious injuriesClosedGrum Amer AA5 · Mechanicville, NYNTSB NYC79FA032Accident · 4 fatalClosedGrum Amer AA-5 · Pompey, NYNTSB NYC76DFA16Accident · No injuriesClosedGrum Amer AA-5 · Haines Falls, NYNTSB NYC74DFA08Accident · No injuriesClosedAmer Avco AA-5 · Mt Upton, NY