NTSB investigations: Cessna 150M, NH
11 cases on aircraft the registry lists as Cessna 150M. 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
| 1968 | 1 |
|---|---|
| 1969 | 1 |
| 1975 | 2 |
| 1976 | 1 |
| 1977 | 1 |
| 1982 | 1 |
| 1984 | 1 |
| 1986 | 1 |
| 1990 | 1 |
| 1995 | 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\" = 'NH' 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 ('2071830'))
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" = 'NH' 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 ('2071830'))
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 NYC96LA037Accident · No injuriesLimited investigationFinal reportCessna 150M · Moultonboro, NHfailure of the pilot to maintain directional control of the airplane during the landing, which allowed the plane to depart the runway and collide with a snowbank. A factor relating to the accident was: the icy runway condition.NTSB NYC90LA188Accident · No injuriesLimited investigationFinal reportCessna 150M · Rochester, NHUndetermined.NTSB NYC86FNC07Accident · Serious injuriesFinal reportCessna 150M · Nashua, NHThe CFI had allowed the student to make the takeoff, witness observed the C150 flying above the rwy at approx 75 to 100 ft with 20 degree flaps. Other witnesses stated that the nose was observed to pitch up then the left wing dropped and the acft went from…NTSB NYC84LA282Accident · No injuriesLimited investigationFinal reportCessna 150M · Claremont, NHAfter a dual instructional flt, practicing landings, the student tookoff on a solo flt. He made 2 takeoffs & landings without incident. On his 3rd takeoff, the acft began drifting to the left. The student said he applied right rudder to correct the situation,…NTSB NYC82DA139Accident · No injuriesFinal reportCessna 150M · Laconia, NHWhen the student pilot was landing, the aircraft veered left after touchdown. It continued down an embankment, ran into a swamp, and was substantially damaged.NTSB NYC77DNC40Accident · No injuriesClosedCessna 150 · Laconia, NHNTSB NYC77DNC10Accident · Minor injuriesClosedCessna 150 · Hampton, NHNTSB NYC76DNC34Accident · No injuriesClosedCessna 150 · Nashua, NHNTSB NYC76DNC14Accident · Minor injuriesClosedCessna 150 · Claremont, NHNTSB NYC69D0321Accident · No injuriesClosedCessna 172 · Rochester, NHNTSB NYC68F0360Accident · No injuriesClosedCessna 172 · Rochester, NH