NTSB investigations: Cessna 150F, MD
18 cases on aircraft the registry lists as Cessna 150F. 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
| 1965 | 1 |
|---|---|
| 1966 | 6 |
| 1967 | 4 |
| 1968 | 1 |
| 1969 | 1 |
| 1970 | 1 |
| 1971 | 1 |
| 1997 | 1 |
| 2000 | 1 |
| 2006 | 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 ('2071814'))
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 ('2071814'))
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 NYC07LA021Accident · No injuriesLimited investigationFinal reportCessna 150F · McHenry, MDThe pilot's inadequate preflight inspection, which resulted in fuel exhaustion and a loss of engine power during takeoff-initial climb.NTSB NYC00LA235Accident · No injuriesLimited investigationFinal reportCessna 150F · Friendly, MDThe pilot's inability to locate the airport, which resulted in fuel exhaustion. A factor related to the accident was the night light conditions.NTSB IAD97FA038Accident · 1 fatalField investigationFinal reportCessna 150F · Bittinger, MDVFR flight by the noninstrumented-rated pilot into instrument meteorological conditions (IMC), which lead to spatial disorientation of the pilot, his loss of aircraft control, and an uncontrolled collision with the terrain. Factors relating to the accident…NTSB IAD71FIA21Accident · Minor injuriesClosedCessna 150 · Lusby, MDNTSB IAD70FIA02Accident · Serious injuriesClosedCessna 150 · Indian Head, MDNTSB IAD70F0064Accident · No injuriesClosedCessna 150F · Crisfield, MDNTSB DIA68A0040Accident · 2 fatalClosedCessna 150F · Churchville, MDNTSB DIA68F0002Accident · Minor injuriesClosedCessna 150 · Michellville, MDNTSB DIA67D0043Accident · No injuriesClosedCessna 150 · College Park, MDNTSB DIA67D0032Accident · No injuriesClosedCessna 150 · Hagerstown, MDNTSB DIA67D0031Accident · No injuriesClosedCessna 150F · Gaithersburg, MDNTSB DIA67F0002Accident · Minor injuriesClosedCessna 150F · Hagerstown, MDNTSB NYC67D0177Accident · No injuriesClosedCessna 150F · Hurlock, MDNTSB NYC67D0065Accident · No injuriesClosedCessna 150 · Frederick, MDNTSB NYC66F0712Accident · No injuriesClosedCessna 150 · Friendly, MDNTSB NYC66F0633Accident · No injuriesClosedCessna 150 · Gaithersburg, MDNTSB NYC66D0507Accident · No injuriesClosedCessna 150 · Gaithersburg, MDNTSB NYC66D0331Accident · Minor injuriesClosedCessna 150 · Gaithersburg, MD