Final NTSB investigations: Morrisey 2150
10 cases on aircraft the registry lists as Morrisey 2150. 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 | 2 |
|---|---|
| 1970 | 2 |
| 1974 | 1 |
| 1978 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1984 | 1 |
| 2014 | 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5940202'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5940202'))
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 WPR14LA096Accident · 2 fatalLimited investigationFinal reportMorrisey 2150 · Pismo Beach, CAThe in-flight separation of a wing for reasons that could not be determined because the wreckage was not recovered from the ocean.NTSB SEA84LA114Accident · No injuriesLimited investigationFinal reportMorrisey 2150 · Enumclaw, WAThe plt was on a local test flt to check the flt controls that had just been adjusted. Before taking off, he visually inspected the fuel tanks, but could not see fuel since anything less than 1/2 tank was not visible. He said the fuel gages indicated both…NTSB LAX82DA276Accident · No injuriesFinal reportMorrisey 2150 · San Carlos, CAThe eng quit from fuel exhaustion & the acft made a forced landing 1/2 mi short of the destination arpt.NTSB FTW82FRJ01Accident · Serious injuriesClosedMorrisey 2150 · Texarkana, TXNTSB LAX79FUJ02Accident · No injuriesClosedVarga 2150 · Chandler, AZNTSB OAK75FVD14Accident · Serious injuriesClosedMorrisey 2150 · Lodi, CANTSB LAX70FUG30Accident · No injuriesClosedMorrisey 2150 · Rubidoux, CANTSB FTW70FRG33Accident · No injuriesClosedMorrisey 2150 · San Antonio, TXNTSB SEA67D0075Accident · No injuriesClosedMorrisey 2150 · Babb, MTNTSB LAX67F0045Accident · Serious injuriesClosedMorrisey 2150 · Perris, CA