NTSB investigations: Cessna 150G, NE
12 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
| 1968 | 2 |
|---|---|
| 1969 | 1 |
| 1970 | 1 |
| 1971 | 2 |
| 1975 | 1 |
| 1979 | 1 |
| 1982 | 1 |
| 1984 | 1 |
| 1986 | 1 |
| 1989 | 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\" = 'NE' 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" = 'NE' 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 MKC89LA086Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Papillion, NEThe contamination of the fuel screen by foreign matter and operation of the aircraft with known deficiencies.NTSB MKC86LA198Accident · No injuriesLimited investigationFinal reportCessna 150G · Weeping Water, NEThe pilot stated that the grass runway threshold dropped off at the lip giving an impression of being too high on final approach. The aircraft struck the incline three feet short of the runway lip, buckling the nose gear. The aircraft slid to a stop off to…NTSB MKC84LA224Accident · No injuriesLimited investigationFinal reportCessna 150 · Kearney, NEAcft nosed over in a corn fld during a forced landing following a loss of pwr. No fuel was found on board the acft. Plt made one stop en route for fuel but was unable to obtain any services as the arpt was unattended.NTSB MKC82DA083Accident · Minor injuriesFinal reportCessna 150 · Chadron, NEAfter flying 1.2 hours with an instructor pilot the student pilot was released for solo flight. The student then flew for .7 hours before running out of fuel. The aircraft nosed over after touching down in a pasture. The instructor pilot stated that the fuel…NTSB MKC79DCJ13Accident · Minor injuriesClosedCessna 150 · Tecumseh, NENTSB MKC76FCJ15Accident · No injuriesClosedCessna 150 · Wayne, NENTSB MKC71DCJ42Accident · No injuriesClosedCessna 150 · Mccook, NENTSB MKC71DCJ39Accident · No injuriesClosedCessna 150G · Lincoln, NENTSB MKC70DCJ33Accident · No injuriesClosedCessna 150 · Lincoln, NENTSB MKC70A0003Accident · 1 fatalClosedCessna 150 · Kearney, NENTSB MKC69F0111Accident · No injuriesClosedCessna 150G · Saronville, NENTSB MKC68F0605Accident · No injuriesClosedCessna 150 · Lincoln, NE