NTSB investigations: Cessna 150G, PA
29 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
| 1966 | 1 |
|---|---|
| 1967 | 4 |
| 1969 | 3 |
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1975 | 2 |
| 1976 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 1981 | 2 |
| 1982 | 1 |
| 1985 | 2 |
| 1990 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1997 | 1 |
| 2010 | 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\" = 'PA' 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" = 'PA' 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 ERA10LA104Accident · No injuriesLimited investigationFinal reportCessna 150G · Doylestown, PAA partial loss of engine power due to carburetor icing.NTSB IAD97LA056Accident · No injuriesLimited investigationFinal reportCessna 150 · Pittsburgh, PAthe student pilot inadvertently became lost/disoriented during a cross-country flight, and failed to use his radio for assistance, which led to fuel exhaustion, loss of engine power, and a forced landing.NTSB BFO93LA098Accident · 1 fatalLimited investigationFinal reportCessna 150 · Milroy, PAThe pilot's inadvertent flight into instrument meteorological conditions, and his failure to maintain clearance with terrain. Factors related to the accident include mountain obscuration and fog.NTSB NYC93LA001Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Lincoln, PAThe pilot's premature liftoff and delay in aborting the takeoff.NTSB NYC90LA093Accident · No injuriesLimited investigationFinal reportCessna C-150 · Turbotville, PAThe pilot to maintain sufficent flying speed for takeoff when strong winds were encountered.NTSB NYC85LA223Accident · No injuriesLimited investigationFinal reportCessna 150G · Reading, PADuring a descent for landing, the eng lost power & the plt made a forced landing in a grass field. However, the grass was damp & the plt was unable to stop the acft before it hit a cyclone fence. According to the local township police, the plt stated the acft…NTSB NYC85FA100Accident · 2 fatalField investigationFinal reportCessna 150G · Acme, PAAt 1221 EST, the plt was advised by a fss that VFR flt was not recommended due to widespread IFR conditions along the route of flt & at the destination. The plt departed at aprx 1430 hrs. At 1700 hrs, witnesses saw the acft flying westbound at low altitude in…NTSB NYC82FA041Accident · Serious injuriesField investigationFinal reportCessna 150G · Erwinna, PAThis was the student's first solo in powered aircraft. He held a private pilot certificate with a glider rating. His takeoff and traffic pattern appeared normal until the last part of his final approach for landing. About 600 ft short of the runway, the…NTSB NYC82FGM05Accident · No injuriesClosedCessna 150G · West Middlesex, PANTSB NYC81FHA10Accident · Minor injuriesClosedCessna 150G · Stroudsburg, PANTSB NYC80FGM14Accident · No injuriesClosedCessna 150G · Marianna, PANTSB NYC79FHA16Accident · No injuriesClosedCessna 150G · Slatington, PANTSB NYC78FGM31Accident · No injuriesClosedCessna 150 · Mt Pleasant, PANTSB NYC77FGT05Accident · No injuriesClosedCessna 150 · Philipsburg, PANTSB NYC75AN117Accident · 2 fatalClosedAeronca 7AC · Macungie, PANTSB NYC75FGT14Accident · No injuriesClosedCessna 150 · University Pk, PANTSB NYC74FGM39Accident · 1 fatalClosedCessna 150 · Tarentum, PANTSB NYC73DGM33Accident · No injuriesClosedCessna 150G · Erie, PANTSB NYC73AN039Accident · 1 fatalClosedCessna 150G · Newtown, PANTSB NYC72FGM08Accident · Serious injuriesClosedCessna 150G · Valencia, PANTSB NYC71AN026Accident · 1 fatalClosedCessna 150 · Warren Center, PANTSB NYC70F0237Accident · No injuriesClosedCessna 150G · Johnstown, PANTSB NYC70D0076Accident · No injuriesClosedCessna 150G · Honesdale, PANTSB NYC69D0462Accident · No injuriesClosedCessna 150 · West Chester, PANTSB NYC68F0329Accident · No injuriesClosedCessna 150G · Bellefonte, PANTSB NYC68D0201Accident · No injuriesClosedCessna 150 · Loganton, PANTSB NYC68F0063Accident · No injuriesClosedCessna 150G · Collegeville, PANTSB NYC67F0497Accident · No injuriesClosedCessna 150 · Tyrone, PANTSB NYC67D0181Accident · No injuriesClosedCessna 150 · Ambler, PA