NTSB investigations: Cessna 150K, MD
13 cases on aircraft the registry lists as Cessna 150K. 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
| 1971 | 1 |
|---|---|
| 1972 | 3 |
| 1973 | 2 |
| 1974 | 2 |
| 1990 | 2 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 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\" = 'MD' 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 ('2071822'))
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" = 'MD' 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 ('2071822'))
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 NYC93LA057Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Hagerstown, MDThe failure of the flight instructor to adequately supervise the student pilot, and take control of the airplane in a timely manner which resulted in the airplane departing the runway and striking a tower. Factors related to the accident were the improper use…NTSB BFO92LA134Accident · No injuriesLimited investigationFinal reportCessna 150G · New Market, MDThe pilot's in-flight planning/decision was inadequate resulting in fuel exhaustion.NTSB BFO91LA079Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Fallston, MDThe pilot's failure to accurately determine the fuel quantity before his flight and monitor the quantity during the flight, which resulted in fuel exhaustion due to an inadequate fuel supply.NTSB BFO91LA002Accident · No injuriesLimited investigationFinal reportCessna 150 · Indian Head, MDThe student pilot's failure to maintain adequate aircraft control during the landing flare/touchdown. Contributing factors are his lack of total flight experience and his improper technique when raising flaps during an attempted go-around.NTSB BFO90FA067Accident · No injuriesField investigationFinal reportCessna 150K · Clinton, MDImproper planning/decision by the instructor pilot (CFI), which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB IAD75FIA04Accident · No injuriesClosedCessna 150 · Clinton, MDNTSB IAD74DIG26Accident · No injuriesClosedCessna 150 · Rhodesdale, MDNTSB IAD74FIG04Accident · Minor injuriesClosedCessna 150K · Edgewater, MDNTSB IAD73DIG21Accident · No injuriesClosedCessna 150K · Salisbury, MDNTSB NYC73FIG19Accident · Minor injuriesClosedCessna 150K · College Park, MDNTSB NYC73FIG08Accident · No injuriesClosedCessna 150K · Sparrows Point, MDNTSB NYC72FIG20Accident · No injuriesClosedCessna 150 · Laurel, MDNTSB NYC72AN024Accident · No injuriesClosedCessna 150K · Frederick, MD