NTSB investigations: Cessna 150L, ME
11 cases on aircraft the registry lists as Cessna 150L. 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
| 1972 | 1 |
|---|---|
| 1974 | 2 |
| 1975 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1982 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1996 | 1 |
| 2001 | 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\" = 'ME' 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 ('2071826'))
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" = 'ME' 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 ('2071826'))
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 NYC01LA149Accident · No injuriesLimited investigationFinal reportCessna 150 · Lincoln, MEA loss of engine power for an undetermined reason.NTSB IAD96LA144Accident · No injuriesLimited investigationFinal reportCessna 150L · Hope, MEinadequate preflight, by not refueling the airplane during an en route stop, which led to fuel exhaustion, loss of engine power, and a subsequent forced landing.NTSB NYC92LA069Accident · No injuriesLimited investigationFinal reportCessna 150 · Sanford, METhe failure of the pilot of N64147 to maintain adequate spacing and visual lookout from N6544G while taxiing, resulting in a ground collision.NTSB NYC92LA015Accident · No injuriesLimited investigationFinal reportCessna 150L · Sanford, METhe failure of the nose wheel through bolt as a result of fatigue cracking.NTSB NYC82DA173Accident · Minor injuriesFinal reportCessna 150L · Shapleigh, METhe pilot departed on a cross-country flight from jackman, ME to rochester, NH and return. Prior to takeoff, the fuel tanks were topped off. During the preflight, the left fuel gauge was found to be "pinned" at the full position and was inoperative. After…NTSB NYC78FA082Accident · 1 fatalClosedCessna 150L · Prospect Harbr, MENTSB NYC77DNC47Accident · No injuriesClosedCessna 150 · Belfast, MENTSB NYC76DNC17Accident · No injuriesClosedCessna 150L · Bangor, MENTSB NYC75DNC10Accident · No injuriesClosedCessna 150 · Old Town, MENTSB NYC74FNC36Accident · No injuriesClosedCessna 150 · Eliot, MENTSB NYC73DNC41Accident · No injuriesClosedCessna 150 · Brewer, ME