NTSB investigations: Cessna 150G, GA
34 cases on aircraft the registry lists as Cessna 150G. 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 | 2 |
|---|---|
| 1968 | 3 |
| 1969 | 3 |
| 1970 | 3 |
| 1971 | 2 |
| 1972 | 2 |
| 1973 | 3 |
| 1974 | 3 |
| 1975 | 2 |
| 1976 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1985 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2017 | 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\" = 'GA' 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 ('2071816'))
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" = 'GA' 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 ('2071816'))
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 ERA17FA330Accident · 1 fatalField investigationFinal reportCessna 150G · Rhine, GAThe student pilot's decision to take off from a partially-lit grass runway in dark night, marginal visual flight rules conditions, which resulted in spatial disorientation, an exceedance of the airplane's critical angle of attack, and an aerodynamic stall.NTSB ATL04FA071Accident · 1 fatalField investigationFinal reportCessna 150G · High Falls, GAThe pilot's impairment due to alcohol which resulted in his failure to maintain adequate airspeed, inadvertent stall, and subsequent in-flight collision with trees.NTSB ATL04LA009Accident · No injuriesLimited investigationFinal reportCessna 150G · Jeykll Island, GAThe pilot's preflight planning and the mismanagement of the fuel supply that resulted in fuel exhaustion.NTSB ATL96FA035Accident · 1 fatalField investigationFinal reportCessna 150G · Social Circle, GAThe flight instructor's inadequate supervision, and his delay in aborting the takeoff.NTSB ATL95LA030Accident · No injuriesLimited investigationFinal reportCessna 150G · Rhine, GAThe failure of the number two cylinder rocker shaft bosses, which resulted in a loss of engine power, and an eventual emergency landing.NTSB ATL94LA026Accident · No injuriesLimited investigationFinal reportCessna 150 · Griffin, GAFuel starvation caused by foreign matter blockage of the fuel tank vent system.NTSB ATL91LA070Accident · No injuriesLimited investigationFinal reportCessna 150G · Villa Rica, GAA loss of engine power for undetermined reasons.NTSB ATL85LA274Accident · No injuriesLimited investigationFinal reportCessna 150G · Dalton, GADuring arrival, the student plt elected to land on a taxiway since the rwy was closed for constuction. He stated that he made a normal pattern, but was a little high on final apch. He reported that he flared about 20 ft above the taxiway, then the acft landed…NTSB MIA78FKG20Accident · No injuriesClosedCessna 150 · Roswell, GANTSB MIA77FKG45Accident · No injuriesClosedCessna 150 · Atlanta, GANTSB DEN76DKG80Accident · Minor injuriesClosedCessna 150 · Statesboro, GANTSB MIA75FKG57Accident · No injuriesClosedCessna 150G · Folkston, GANTSB MIA75DK656Accident · Minor injuriesClosedCessna 150G · Ellijay, GANTSB MIA75FKG31Accident · No injuriesClosedCessna 150 · Marietta, GANTSB MIA74FKG86Accident · Minor injuriesClosedCessna 150G · Williamson, GANTSB MIA74AM086Accident · Serious injuriesClosedCessna 150G · Stone Mountain, GANTSB MIA74FKG29Accident · Serious injuriesClosedCessna 150G · Jonesboro, GANTSB MIA74FKG04Accident · No injuriesClosedCessna 150 · Dalton, GANTSB MIA73AM102Accident · 2 fatalClosedCessna 150G · Hiram, GANTSB MIA73FKG53Accident · No injuriesClosedCessna 150G · Chamblee, GANTSB MIA72FKG88Accident · No injuriesClosedCessna 150G · Winston, GANTSB MIA72DKG23Accident · No injuriesClosedCessna 150G · Gray, GANTSB MIA71FKG82Accident · No injuriesClosedCessna 150G · Quitman, GANTSB MIA71FKG25Accident · Minor injuriesClosedCessna 150G · Atlanta, GANTSB MIA70DKG20Accident · No injuriesClosedCessna 150 · Marietta, GANTSB MIA70DKG13Accident · No injuriesClosedCessna 150 · Chamblee, GANTSB MIA70F0142Accident · No injuriesClosedCessna 150 · Twin City, GANTSB MIA70F0082Accident · No injuriesClosedCessna 150G · Villa Rica, GANTSB MIA69F0363Accident · No injuriesClosedCessna 150G · Lithonia, GANTSB MIA68A0084Accident · 2 fatalClosedCessna 150G · Lilburn, GANTSB MIA68F0014Accident · No injuriesClosedCessna 150 · Stone Mountain, GANTSB MIA68A0076Accident · 2 fatalClosedCessna 150G · Columbus, GANTSB MIA68D0041Accident · No injuriesClosedCessna 150 · Lithonia, GANTSB MIA68D0010Accident · No injuriesClosedCessna 150 · Allentown, GA