NTSB investigations: Grumman American Avn. GA-7
6 cases on aircraft the registry lists as Grumman American Avn. GA-7. 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
| 1980 | 1 |
|---|---|
| 1982 | 1 |
| 1987 | 1 |
| 2020 | 1 |
| 2024 | 1 |
| 2026 | 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 ('3960401'))
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 ('3960401'))
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 ERA26LA357Accident · No injuriesClass 4 · LimitedInvestigation openGrumman American Avn. GA-7 · Knoxville, TNNTSB ERA24FA103Accident · 1 fatalClass 3 · FieldFinal reportGrumman American Avn. GA-7 · Coatesville, PAThe pilot’s inadequate preflight inspection, which resulted in a loss of engine power due to water-contaminated fuel, and his subsequent loss of control. Contributing to the accident was an inadequate annual maintenance inspection, during which maintenance…NTSB ERA21LA035Accident · 3 fatalClass 3 · LimitedFinal reportGrumman GA7 · Ellicott, NYThe pilot’s continued descent below the minimum descent altitude while conducting an instrument approach in instrument meteorological conditions, which resulted in controlled flight into terrain.NTSB FTW88LA003Accident · No injuriesLimited investigationFinal reportGrumman GA7 · Covington, LAThe pilot touched down with excessive speed, and due to the poor mechanical condition of the aircraft's brakes, was unable to stop before over-running the departure end of the runway. The aircraft's annual inspection was two months overdue. The pilot's…NTSB MKC83FA017Accident · 1 fatalField investigationFinal reportGrumman American GA-7 · Norfolk, NEThe aircraft collided with trees and crashed in an open meadow during an instrument approach at night. The pilot said the landing lights reflected in his eyes during approach so he turned them off. The pilot failed to obtain the latest weather before his…NTSB FTW80FAMS3Accident · 4 fatalClosedGrum-Amer GA-7 · Corpus Christi, TX