NTSB investigations: Cessna 150J, PA
32 cases on aircraft the registry lists as Cessna 150J. 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
| 1969 | 3 |
|---|---|
| 1970 | 4 |
| 1971 | 4 |
| 1973 | 7 |
| 1976 | 2 |
| 1977 | 1 |
| 1981 | 2 |
| 1988 | 1 |
| 1991 | 1 |
| 1994 | 1 |
| 1995 | 2 |
| 2001 | 2 |
| 2007 | 1 |
| 2024 | 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\" = '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 ('2071820'))
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 ('2071820'))
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 ERA24LA389Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Erie, PAThe student pilot’s improper landing flare and subsequent improper recovery from a bounced landing and the flight instructor’s inadequate remedial action.NTSB NYC07LA210Accident · 1 fatalLimited investigationFinal reportCessna 150J · Hazleton, PAThe pilot’s failure to maintain airspeed while maneuvering at low altitude.NTSB NYC01LA146Accident · Minor injuriesLimited investigationFinal reportCessna 150J · West Mifflin, PAThe pilot's failure to maintain airspeed while picking up a banner, and subsequent delay in releasing the banner, resulting in a stall/mush.NTSB NYC01LA115Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Osceola Mills, PAA partial power loss due to a stuck exhaust valve in the # 2 cylinder, which resulted in a forced landing. A factor was the rising terrain.NTSB NYC96LA045Accident · No injuriesLimited investigationFinal reportCessna 150J · Kutztown, PAthe student pilot's selection of an unsuitable runway for landing. The snow covered runway was a related factor.NTSB NYC95LA077Accident · No injuriesLimited investigationFinal reportCessna 150J · Slatington, PAThe pilot's improper use of carburetor heat which resulted in carburetor icing and a subsequent loss of engine power. A factor is carburetor icing conditions.NTSB NYC94LA125Accident · No injuriesLimited investigationFinal reportCessna 150J · Coatsville, PAThe pilot's inadequate use of carburetor hear. A factor was carburetor icing conditions and soft terrain.NTSB NYC91LA204Accident · No injuriesLimited investigationFinal reportCessna 150J · Burgettstown, PAThe pilot-in-command's failure to maintain control of the airplane on the landing roll, resulting in an on ground collision with a tree. Factors related to the accident was the pilot's improper use of the brake system.NTSB NYC88LA118Accident · No injuriesLimited investigationFinal reportCessna 150 · Downingtown, PADuring takeoff from shannon airport, the flight experienced an engine power loss and crashed. Pilot stated that water was found in the carburetor. The plt said after the acc that after the power loss he noticed powerlines and houses in front and made a sharp…NTSB NYC81FGM02Accident · Serious injuriesClosedCessna 150J · Dubois, PANTSB NYC81FGM31Accident · No injuriesClosedCessna 150J · Belle Vernon, PANTSB NYC78DGM02Accident · Serious injuriesClosedCessna 150 · Edinboro, PANTSB NYC76DHD44Accident · No injuriesClosedCessna 150J · Blue Bell, PANTSB NYC76FHA26Accident · Minor injuriesClosedCessna 150 · Bushkill, PANTSB NYC74FHA04Accident · No injuriesClosedCessna 150J · Honesdale, PANTSB NYC73FGM23Accident · No injuriesClosedCessna 150J · Smithton, PANTSB NYC73FHD29Accident · No injuriesClosedCessna 150 · Bristol, PANTSB NYC73FGM22Accident · No injuriesClosedCessna 150J · Beaver Falls, PANTSB NYC73FGM20Accident · No injuriesClosedCessna 150J · Belle Vernon, PANTSB NYC73DGM19Accident · No injuriesClosedCessna 150 · West Mifflin, PANTSB NYC73FGM17Accident · No injuriesClosedCessna 150 · West Mifflin, PANTSB NYC72DGM15Accident · No injuriesClosedCessna 150 · Eighty Four, PANTSB NYC72FGT02Accident · No injuriesClosedCessna 150J · Dallastown, PANTSB NYC71FGM52Accident · Minor injuriesClosedCessna 150J · Beaver Falls, PANTSB NYC71FGM38Accident · No injuriesClosedCessna 150 · West Mifflin, PANTSB NYC71FHA12Accident · Minor injuriesClosedCessna 150 · Collegeville, PANTSB NYC71DHA39Accident · No injuriesClosedCessna 150J · Avoca, PANTSB NYC70DHD12Accident · No injuriesClosedCessna 150 · Ambler, PANTSB NYC70FHD04Accident · No injuriesClosedCessna 150 · Philadelphia, PANTSB NYC70F0183Accident · No injuriesClosedCessna 150 · Collegeville, PANTSB NYC70D0133Accident · No injuriesClosedCessna 150 · Ambler, PANTSB NYC69D0305Accident · Minor injuriesClosedCessna 150 · Sweet Valley, PA