NTSB investigations: Grumman American Avn. AA-5B
6 cases on aircraft the registry lists as Grumman American Avn. AA-5B, where the first occurrence was “In flight collision with terrain/water”. 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
| 1982 | 1 |
|---|---|
| 1990 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2002 | 1 |
| 2003 | 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 ('3960105')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230))
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 ('3960105')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230))
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 NYC03FA176Accident · 1 fatalField investigationFinal reportGrumman AA-5B · Pleasantville, PAThe pilot's improper IFR procedure by his failure to maintain published altitudes, which resulted in the in-flight collision with terrain. A factor was his impairment due to prescription medication.NTSB LAX02FA200Accident · 2 fatalField investigationFinal reportGrumman American AA-5B · Santa Paula, CAthe pilot's attempted VFR flight into instrument conditions and failure to maintain clearance with the terrain.NTSB IAD00FA082Accident · 1 fatalField investigationFinal reportGrumman AA-5B · Carrollton, OHPilot's improper decision to delay the aborted landing, which resulted in an insufficient airspeed during climb and subsequent collision with terrain. A factor was the wet runway and tailwind.NTSB SEA98LA132Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5B · Chico Hot Sprgs, MTThe pilot-in-command's selection of the wrong runway for takeoff. Factors contributing to the accident were high density altitude, rising terrain and a fence post.NTSB ATL90FA183Accident · 2 fatalField investigationFinal reportGrumman AA5B · Gallatin, TNThe pilot's failure to maintain the proper altitude which resulted in the inadvertent descent into the ground, and his diverted attention to another airplane. Factors in the accident were fog, dark night, fatigue from lack of sleep, and a lack of recent night…NTSB LAX82FA040Accident · 2 fatalField investigationFinal reportGrumman AA-5B · 10 Nm W Lee Vin, CAWhile on the ground the pilot was refused a route over the sierra mountains, after departure the pilot requested and was given a change in his flight plan that cleared him over the mountains. At 1654 the pilot advised oakland center that he was climbing…