NTSB investigations: Grumman G-159
7 cases on aircraft the registry lists as Grumman G-159. 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
| 1967 | 1 |
|---|---|
| 1974 | 1 |
| 1978 | 1 |
| 1983 | 1 |
| 1990 | 1 |
| 1993 | 1 |
| 1997 | 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 ('3952202'))
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 ('3952202'))
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 IAD97WA067Accident · No injuriesForeign investigationGulfstream G1 · Goma, UgandaNTSB FTW94IA035Incident · No injuriesIncident investigationFinal reportGrumman G159 · Pineville, LAAn encounter with a wet microburst, on final approach at 200 feet AGL, which exceeded the performance capability of the aircraft.NTSB FTW90MA161Accident · 3 fatalMajor investigationFinal reportGrumman G-159 · Houston, TXPartial failure of the left engine fuel pump, which resulted in a partial loss of power in the left engine, but not enough of a power loss to trigger and/or complete the autofeathering operation of the left propeller, thus allowing insufficient time for the…NTSB DCA83AA032Accident · Minor injuriesFinal reportGrumman G-159 · Blountville, TNThe coplt stated that when he began the apch to the destination arpt, the weather condition was hazy & he delayed his descent slightly until he located the arpt. When he saw the rwy, he believed that they were a little too close, so he indicated to the…NTSB FTW78FA084Accident · Serious injuriesClosedGrumman G-159 · Houston, TXNTSB IAD74II054Incident · No injuriesClosedGrumman G-159 · Charlestown, SCNTSB MKC68A0003Accident · 2 fatalClosedGrumman G-159 · Le Center, MN