NTSB investigations: Grumman American Avn. AA-5, MD
7 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
| 1974 | 1 |
|---|---|
| 1982 | 1 |
| 1983 | 1 |
| 1991 | 2 |
| 1993 | 1 |
| 1996 | 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\" = 'MD' 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" = 'MD' 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 IAD96LA139Accident · Minor injuriesLimited investigationFinal reportAmerican AA-5 · Annapolis, MDfailure of the pilot to maintain adequate airspeed after takeoff, which resulted in a stall and subsequent collision with water.NTSB BFO93LA024Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5 · Lanham, MDThe blockage of the right and left fuel vent line which prevented the flow of fuel to the engine causing total power loss.NTSB BFO91LA070Accident · Serious injuriesLimited investigationFinal reportGrumman AA5 · Oakland, MDThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB BFO91LA065Accident · No injuriesLimited investigationFinal reportGrumman AA-5 · Clarksville, MDThe pilot's improper flare and failure to arrest his descent rate.NTSB DCA83IA027Incident · No injuriesIncident investigationFinal reportGrumman AA-5 · Clinton, MDThe student pilot ballooned during the flare, then landed hared on runway. The nosegear failed and the acft slid down the runway.NTSB ATL83LA038Accident · No injuriesLimited investigationFinal reportGrumman AA5 · Clinton, MDThe pilot was on final approach behind a Cessna 150 and thought the Cessna would turn off at the first taxiway. The Cessna continued to the second taxiway and the pilot of N5442L elected to go-around. The pilot stated the aircraft seemed to mush as it flew…NTSB IAD75FIA01Accident · No injuriesClosedGrumman AA5 · California, MD