NTSB investigations: Cessna 150G, AL
33 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 | 7 |
|---|---|
| 1968 | 3 |
| 1969 | 5 |
| 1971 | 3 |
| 1976 | 1 |
| 1980 | 1 |
| 1985 | 1 |
| 1988 | 2 |
| 1990 | 1 |
| 1991 | 1 |
| 1996 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 2 |
| 2007 | 1 |
| 2021 | 1 |
| 2022 | 1 |
Where
Latest 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\" = 'AL' 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" = 'AL' 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 ERA22LA321Accident · No injuriesClass 4 · LimitedFinal reportCessna 150G · Tuscaloosa, ALThe student pilot’s inadvertent use of the fuel mixture knob instead of the carburetor heat knob, which resulted in fuel starvation and a subsequent loss of engine power.NTSB ERA21LA217Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Brewton, ALThe pilot’s failure to maintain adequate airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall and impact with the ground.NTSB ATL07CA072Accident · Minor injuriesData collectionFinal reportCessna C-150G · Enterprise, ALThe CFI's attempted takeoff with known deficiencies in the engine which resulted in a loss of engine power, a forced landing on muddy terrain, and a nose over.NTSB ATL03LA096Accident · No injuriesLimited investigationFinal reportCessna 150G · Morris, ALThe pilot's selection of unsuitable terrain for a precautionary landing, which resulted in a ground collision with terrain, and subsequent collapse of the nose gear.NTSB ATL03LA086Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Montgomery, ALThe in-flight collision with birds that resulted in a partial loss of engine power, and subsequent in-flight collision with trees while maneuvering for an emergency landing.NTSB ATL02FA143Accident · 2 fatalField investigationFinal reportCessna 150G · Duncanville, ALThe pilot's failure to maintain airspeed , which resulted in an inadvertent stall, and subsequent collision with the ground. A contributing factor was low level flight.NTSB ATL01LA057Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Pell City, ALThe pilot's selection of the wrong runway that resulted in an attempted takeoff with a tailwind.NTSB MIA97LA026Accident · No injuriesLimited investigationFinal reportCessna 150 · Gulf Shores, ALInadequate maintenance/inspection of the aircraft engine, which allowed continued use of a deteriorated ignition harness and subsequent loss of engine power.NTSB ATL91LA177Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Pleasant Grove, ALThe pilot's failure to refuel the airplane prior to the last takeoff resulting in an inadequate fuel supply for the flight.NTSB ATL90FA141Accident · 1 fatalField investigationFinal reportCessna 150G · Lanett, ALFailure of the pilot to maintain adequate airspeed, which resulted in a stall.NTSB ATL88LA253Accident · No injuriesLimited investigationFinal reportCessna 150G · Luverne, ALThe plt reported that he was flying at about 7-800 ft AGL while inspecting timber for insect damage when the engine suddenly lost power. He could not recover enough power to sustain flt, so he selected a pasture for his impending forced ldg. He reported that…NTSB ATL88LA124Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Muscle Shoals, ALThe airplane experienced a loss of electrical power during the local, solo flt. The student elected to make a precautionary ldg at Muscle Shoals arpt (MSL) which was the nearest arpt. He made two attempts to land on rwy 36, with a 12-20 kt tailwind: on the…NTSB ATL85FA243Accident · 1 fatalField investigationFinal reportCessna 150G · Selma, ALAcft took off from sod strip on hot humid day near max weight. PIC said he used 10 degrees flaps and was airborne. At about runway mid point. When over first tree line after passing threshold acft descended. When over brown terrain acft climbed. When over…NTSB MIA80FKJ20Accident · No injuriesClosedCessna 150 · North Johns, ALNTSB MIA77DKJ06Accident · Minor injuriesClosedCessna 150 · Eufaula, ALNTSB MIA72IM013Incident · 1 fatalClosedCessna 150G · Foley, ALNTSB MIA71DKJ60Accident · No injuriesClosedCessna 150 · Guin, ALNTSB MIA71DKJ59Accident · No injuriesClosedCessna 150 · Muscle Shoals, ALNTSB MIA70D0264Accident · No injuriesClosedCessna 150 · St Elmo, ALNTSB MIA70F0224Accident · No injuriesClosedCessna 150G · Moulton, ALNTSB MIA70D0157Accident · No injuriesClosedCessna 150 · Hillsboro, ALNTSB MIA69A0079Accident · 1 fatalClosedCessna 150G · Riverview, ALNTSB MIA69D0437Accident · No injuriesClosedCessna 150 · Tuscaloosa, ALNTSB MIA69D0130Accident · No injuriesClosedCessna 150G · Montgomery, ALNTSB MIA69D0158Accident · No injuriesClosedCessna 150 · Mt.Vernon, ALNTSB MIA69F0001Accident · No injuriesClosedCessna 150G · Geraldine, ALNTSB MIA68D0369Accident · No injuriesClosedCessna 150 · Pell City, ALNTSB MIA68D0365Accident · No injuriesClosedCessna 150G · Enterprise, ALNTSB MIA68F0216Accident · Serious injuriesClosedCessna 150 · Hazel Green, ALNTSB MIA68D0049Accident · No injuriesClosedCessna 150 · Linden, ALNTSB MIA67F0580Accident · No injuriesClosedCessna 150 · Ozark, ALNTSB MIA68D0098Accident · No injuriesClosedCessna 150G · Mobile, ALNTSB MIA67D0518Accident · Minor injuriesClosedCessna 150G · Cullman, AL