NTSB investigations: Grumman American Avn. AA-1C
6 cases on aircraft the registry lists as Grumman American Avn. AA-1C, where the first occurrence was “Loss of control - in flight”. 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
| 1984 | 1 |
|---|---|
| 1989 | 2 |
| 1995 | 1 |
| 2001 | 1 |
| 2006 | 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 ('3960100')
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\" = 250))
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 ('3960100')
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" = 250))
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 LAX06CA146Accident · Minor injuriesData collectionFinal reportGrumman American AA-1C · San Diego, CAThe pilot's failure to maintain adequate airspeed, which resulted in a stall during initial climb. A contributing factor was his diverted attention.NTSB NYC01FA169Accident · 2 fatalField investigationFinal reportGrumman American AA-1C · Medford, NJThe pilot's improper use of the flight controls while turning to base, which resulted in a stall/spin and subsequent impact with the ground.NTSB ATL95LA112Accident · Minor injuriesLimited investigationFinal reportGrumman AA1C · Mocksville, NCThe pilot's improper short field takeoff procedure which resulted in the inadvertent stall/mush during the takeoff.NTSB CHI89LA148Accident · No injuriesLimited investigationFinal reportGrumman AA-1C · Madison, INThe student's failure to maintain directional control of the aircraft and the cfi's delay in taking remedial action to regain control. Contributing to the accident was the students lack of total experience.NTSB LAX89LA222Accident · 2 fatalLimited investigationFinal reportAmerican AA-1C · Kalaupapa, HIThe pilot's failure to maintain sufficient airspeed to prevent a stall from which there was insufficient altitude to recover.NTSB CHI84LA228Accident · No injuriesLimited investigationFinal reportGrumman AA-1C · Madison, INThe student plt was practicing touch-&-go landings with an Aeronca in the traffic pattern ahead of him. He stated that when he touched down, the Aeronca was still on the rwy, so he decided to abort the landing to avoid the other acft. The plt stated he had…