NTSB investigations: Cessna 150G, NJ
17 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
| 1966 | 1 |
|---|---|
| 1967 | 5 |
| 1968 | 2 |
| 1969 | 1 |
| 1973 | 2 |
| 1974 | 2 |
| 1975 | 1 |
| 1979 | 1 |
| 2014 | 1 |
| 2023 | 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\" = 'NJ' 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" = 'NJ' 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 ERA23LA371Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150G · Cross Keys, NJThe pilot’s failure to maintain adequate airspeed during the banner pickup, which resulted in a low altitude aerodynamic stall/spin.NTSB ERA14LA401Accident · No injuriesLimited investigationFinal reportCessna 150G · Pittstown, NJA total loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB NYC79FA079Accident · 1 fatalClosedCessna 150 · Pennington, NJNTSB NYC75FHD35Accident · Minor injuriesClosedCessna 150G · Manahawkin, NJNTSB NYC75DHD22Accident · No injuriesClosedCessna 150 · Smithville, NJNTSB NYC74DHA27Accident · No injuriesClosedCessna 150G · Pittstown, NJNTSB NYC74DHD19Accident · No injuriesClosedCessna 150 · Hammonton, NJNTSB NYC73FHD32Accident · Minor injuriesClosedCessna 150G · Rancocas, NJNTSB NYC70D0014Accident · No injuriesClosedCessna 150 · Williamstown, NJNTSB NYC69D0257Accident · No injuriesClosedCessna 150 · Aptistown, NJNTSB NYC68D0478Accident · No injuriesClosedCessna 150 · Montville Twp, NJNTSB NYC68F0269Accident · No injuriesClosedCessna 150 · Teterboro, NJNTSB NYC68D0263Accident · Minor injuriesClosedCessna 150 · Toms River, NJNTSB NYC68F0096Accident · No injuriesClosedCessna 150 · Medford, NJNTSB NYC67D0699Accident · No injuriesClosedCessna 150 · Sewell, NJNTSB NYC67D0489Accident · No injuriesClosedCessna 150 · Sewell, NJNTSB NYC67D0290Accident · Minor injuriesClosedCessna 150 · Long Valley, NJ