NTSB investigations: Schweizer G-164B, LA
12 cases on aircraft the registry lists as Schweizer G-164B. 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
| 1981 | 2 |
|---|---|
| 1986 | 1 |
| 1987 | 1 |
| 1996 | 1 |
| 2000 | 1 |
| 2002 | 2 |
| 2008 | 1 |
| 2009 | 1 |
| 2012 | 1 |
| 2024 | 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.\"eventStateOrRegion\" = 'LA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8059055'))
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."eventStateOrRegion" = 'LA' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8059055'))
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 CEN24LA146Accident · No injuriesClass 3 · LimitedFinal reportSchweizer G-164B · Kaplan, LAA partial loss of engine power for reasons that could not be determined.NTSB CEN12CA544Accident · Serious injuriesData collectionFinal reportSchweizer, N36289 G-164B · Kaplan, LAThe pilot's failure to maintain clearance from power lines during the aerial application flight.NTSB CEN09CA151Accident · No injuriesData collectionFinal reportSchweizer G-164B · Ferriday, LAThe pilot's loss of control following an impact with birds.NTSB DFW08LA089Accident · No injuriesLimited investigationFinal reportPiper PA24-260 · Abbeville, LAThe failure of both pilots to see and avoid the other approaching airplane. A contributing factor was the close proximity between the two private airstrips.NTSB FTW02LA239Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Simmesport, LAthe contamination of the fuel system with water and a foreign material.NTSB FTW02LA107Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Ferriday, LAthe failure of the number three cylinder exhaust rocker arm, resulting in a total loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA233Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Deerpark, LAthe failure of both pilots to maintain a visual outlook during landing approach. A contributing factor was both pilot's failure to follow recommended traffic patterns.NTSB FTW96LA388Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Ferriday, LAThe partial loss of engine power due to a cracked cylinder head. Factors were the oil leak which restricted the pilot's visual lookout and the lack of suitable terrain for the forced landing.NTSB FTW87DRD07Accident · No injuriesFinal reportGrumman G-164B · Chenneyville, LAThe engine experienced a total loss of power due to a failed #1 connecting rod. During the forced landing the left wing contacted cotton plants which caused the aircraft to veer left and flip inverted.NTSB FTW86LRD23Accident · No injuriesFinal reportGrumman G-164B · Lecompte, LAThe plt was engaged in an aerial application flt when a thunderstorm developed to the southwest of the airstrip. The plt was attempting to land to the east before the storm hit. Control of the acft was lost after touchdown and the acft nosed over. A 25 to 40…NTSB FTW81FRJ32Accident · Serious injuriesClosedGrumman G-164B · Mer Rouge, LANTSB FTW81DRJ23Accident · No injuriesClosedGrumman G-164B · Hebert, LA