NTSB investigations: Grumman American Avn. AA-5B
10 cases on aircraft the registry lists as Grumman American Avn. AA-5B, where the first occurrence was “In flight encounter with weather”. 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 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1997 | 2 |
| 2002 | 2 |
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\" = 240))
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" = 240))
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 ATL02FA162Accident · 2 fatalField investigationFinal reportAmerican General AA-5B · Zephyrhills, FLThe pilots continued visual flight into instrument conditions (fog), and subsequent collision with a tree and a residence.NTSB DEN02LA075Accident · Serious injuriesLimited investigationFinal reportAmerican General AA5B · Worland, WYthe pilot's selection of an inadequate altitude for crossing mountainous terrain, resulting in a collision with trees. A contributing factor was the downdraft.NTSB LAX97LA236Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Susanville, CAthe pilot's inadvertent encounter with unfavorable weather conditions during the landing, and his failure to maintain runway alignment. The sudden onset of crosswind gusts beyond the capability of the aircraft was a related factor.NTSB NYC97FA139Accident · 3 fatalField investigationFinal reportGrumman American AA-5B · Jones Beach, NYVFR flight by the pilot into instrument meteorological conditions (IMC), and his loss of aircraft control due to spatial disorientation, which resulted in an uncontrolled descent and collision with terrain (water). Related factors were: the adverse weather…NTSB NYC90FA099Accident · 1 fatalField investigationFinal reportGrumman AA-5B · Fredericksburg, PAContinued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure (or inability) to maintain control of the aircraft after becoming spatially disoriented. Factors related to the accident were: adverse weather conditions, and…NTSB LAX88FA118Accident · 2 fatalField investigationFinal reportGrumman AA-5B · Frazier Park, CAImproper maintenance performed previous to the accident flight which failed to identify a fault which rendered the airplane nonairworthy. Contributing to this accident was the pilot's exercise of poor judgement in disregarding weather forecasts indicating…NTSB BFO87FA046Accident · 1 fatalField investigationFinal reportGrumman AA-5B · Abingdon, VAFss advised the plt that VFR flight was not recommended due to obscured mountains along the flight route. There also were thundershowers west of the flight route. The plt said he had to leave to stay ahead of the thundershowers. He said that he would fly the…NTSB LAX86FA038Accident · 3 fatalField investigationFinal reportGrumman American AA-5B · Gold Run, CAThe accident location and the departure airport is located in a mountainous area. The acft departed truckee-tahoe arpt (trk) to the northeast in marginal VFR conditions at sunset. The acft continued on a northeasterly heading for 18 miles and then turned to a…NTSB LAX84FA280Accident · 1 fatalField investigationFinal reportGrumman American AA-5B · Placerville, CAThe plt lived near the arpt & had been commuting to sacramento, CA for about 3 weeks. Rwy 27 was the prominant rwy & the arpt was surrounded by hills. Shortly after taking off, the acft crashed about 2 mi west of the arpt while in a right wing low attitude on…NTSB DEN83FTC01Accident · 2 fatalFinal reportGrumman American AA-5B · Albin, WYThe pilot was on personal cross-country. There was no record of a pre-flight or in-flight weather briefing. The weather at the accident site was near blizzard condition. The aircraft was heard circling, but it was not seen due to snow. The winds approached 50…