NTSB investigations: Cessna 150, PA
18 cases on aircraft the registry lists as Cessna 150. 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
| 1964 | 3 |
|---|---|
| 1965 | 1 |
| 1966 | 4 |
| 1968 | 1 |
| 1970 | 1 |
| 1971 | 3 |
| 1974 | 1 |
| 1975 | 1 |
| 1989 | 1 |
| 1995 | 1 |
| 2007 | 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 ('2071802'))
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 ('2071802'))
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 NYC07CA154Accident · No injuriesData collectionFinal reportCessna 150 · Lancaster, PAThe pilot's decision to conduct the flight while impaired by alcohol, which resulted in fuel exhaustion and substantial damage to the airplane during the subsequent forced landing.NTSB NYC95LA196Accident · Serious injuriesLimited investigationFinal reportCessna 150 · North East, PAThe student pilot's delay in initiating an aborted landing and his failure to attain obstacle clearance.NTSB NYC89LA077Accident · No injuriesLimited investigationFinal reportCessna 150 · Craley, PAThe loss of control during takeoff due to a pilot induced stall. Contributing to the accident was the wrong runway selected by the pilot which put the aircraft in a downwind takeoff situation and the pilots misjudgement of the distance it would take the…NTSB NYC75FHD42Accident · Minor injuriesClosedCessna 150L · Toughkenamon, PANTSB NYC75FHA17Accident · No injuriesClosedCessna 150 · Slatington, PANTSB NYC71FHA48Accident · No injuriesClosedCessna 150 · Allentown, PANTSB NYC71DHA35Accident · No injuriesClosedCessna 150 · Honesdale, PANTSB NYC71FHA28Accident · No injuriesClosedCessna 150 · Allentown, PANTSB NYC70DHD13Accident · Minor injuriesClosedCessna 150 · Ambler, PANTSB NYC69D0052Accident · No injuriesClosedCessna 150 · Bridgeville, PANTSB NYC67F0300Accident · No injuriesClosedCessna 150 · Carlisle, PANTSB NYC67D0005Accident · No injuriesClosedCessna 150 · Neffsville, PANTSB NYC66F0508Accident · No injuriesClosedCessna 150 · New Cumberland, PANTSB NYC66D0433Accident · No injuriesClosedCessna 150 · Ambler, PANTSB NYC66F0289Accident · No injuriesClosedCessna 150 · West Chester, PANTSB UNK65X0435Accident · No injuriesClosedCessna 150 · Clarion, PANTSB UNK65X0154Accident · No injuriesClosedCessna 150 · Allentown, PANTSB UNK64X2750Accident · Minor injuriesClosedCessna 150 · Ambler, PA