NTSB investigations: Cessna 150G, CT
13 cases on aircraft the registry lists as Cessna 150G. 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
| 1967 | 4 |
|---|---|
| 1968 | 2 |
| 1970 | 1 |
| 1972 | 1 |
| 1974 | 1 |
| 1976 | 1 |
| 1980 | 1 |
| 1982 | 1 |
| 2005 | 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\" = 'CT' 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 ('2071816'))
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" = 'CT' 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 ('2071816'))
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 NYC05CA090Accident · No injuriesData collectionFinal reportCessna 150G · Willimantic, CTThe student pilot's improper recovery from a bounced landing and his failure to maintain directional control while landing.NTSB NYC82DA220Accident · Minor injuriesFinal reportCessna 150G · East Haddam, CTThe pilot reported that just prior to flaring, the aircraft had started drifting to the left; therefore, a decision was made to abort the landing. A go-around was initiated and flap retraction was started. However, the aircraft stalled and landed in a swamp.NTSB NYC80FNE21Accident · No injuriesClosedCessna 150G · Franklin, CTNTSB NYC76AN073Accident · 2 fatalClosedCessna 150 · Bridgeport, CTNTSB NYC74FNE24Accident · Minor injuriesClosedCessna 150 · Sherman, CTNTSB NYC73DNE05Accident · No injuriesClosedCessna 150G · Ansonia, CTNTSB NYC70DFM03Accident · No injuriesClosedCessna 150 · East Windsor, CTNTSB NYC68D0426Accident · No injuriesClosedCessna 150 · Thompson, CTNTSB NYC68D0327Accident · No injuriesClosedCessna 150 · Plainville, CTNTSB NYC68F0322Accident · No injuriesClosedCessna 150G · Hartford, CTNTSB NYC68D0054Accident · No injuriesClosedCessna 150 · Ellington, CTNTSB NYC67D0681Accident · No injuriesClosedCessna 150 · Plainville, CTNTSB NYC67F0568Accident · No injuriesClosedCessna 150 · Simsbury, CT