NTSB investigations: Cessna 150J, NE
9 cases on aircraft the registry lists as Cessna 150J. 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
| 1970 | 1 |
|---|---|
| 1972 | 1 |
| 1973 | 2 |
| 1974 | 1 |
| 1976 | 1 |
| 1979 | 1 |
| 1982 | 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\" = '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 ('2071820'))
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 ('2071820'))
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 CHI93LA117Accident · No injuriesLimited investigationFinal reportCessna 150J · Hastings, NEThe pilot's failure to refuel the airplane en route which resulted in an inadequate fuel supply for the flight.NTSB MKC83LA021Accident · No injuriesLimited investigationFinal reportCessna 150J · Wahoo, NEPlt thought he heard an unusual noise just after lift-off & aborted. The acft ran off the end of the rwy & overturned. The owner examined the acft & was unable to determine the source of the noise. The plt later stated he didn't know what the noise was, &…NTSB MKC80FCJ02Accident · Minor injuriesClosedCessna 150J · Nebraska City, NENTSB MKC76FCJ30Accident · No injuriesClosedCessna 150J · Tecumseh, NENTSB MKC75DCJ05Accident · No injuriesClosedCessna 150 · Potter, NENTSB MKC74DCJ05Accident · No injuriesClosedCessna 150J · North Platte, NENTSB MKC73DCJ32Accident · No injuriesClosedCessna T-50 · Omaha, NENTSB MKC72DCJ68Accident · No injuriesClosedCessna 150 · Lincoln, NENTSB MKC71FCJ31|MKC71FCJ32Accident · No injuriesClosedCessna 150 · Columbus, NE