Skip to content

NTSB investigations · 20

Matched to the registry by N-number and event date, newest first.

Query with SQL

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.aircraft_model_code IN ('5940204') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.aircraft_model_code IN ('5940204')
  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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('5940204')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 ERA17FA232Accident · 1 fatalField investigationFinal reportMorrisey 2150A · Honesdale, PAA total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's use of two psychoactive substances, which led to his impaired decision to attempt to takeoff after engine issues became evident.Jul 6, 2017 · N917JL · Substantial damage NTSB ERA11CA315Accident · No injuriesData collectionFinal reportMorrisey 2150A · Cambridge, MDThe pilot's loss of directional control during landing on a soft, turf runway.May 21, 2011 · N5122V · Substantial damage NTSB LAX07LA011Accident · Minor injuriesLimited investigationFinal reportMorrisey 2150A · Chandler, AZLoss of engine power during cruise flight due to a crack in the oil cooler and subsequent loss of engine oil.Oct 18, 2006 · N5114V · Substantial damage NTSB NYC99LA209Accident · Serious injuriesLimited investigationFinal reportMorrisey 2150A · Ellisburg, NYThe pilot's delay in applying carburetor heat which resulted in the loss of power, and his misjudgment of the flare during the forced landing.Aug 24, 1999 · N312BW · Substantial damage NTSB SEA93LA009Accident · Minor injuriesLimited investigationFinal reportMorrisey Shinn 2150A · Dallas, ORFailure to maintain airspeed. Factors include an improper fuel selector setting, and fuel starvation.Oct 23, 1992 · N5131V · Substantial damage NTSB ATL90LA047Accident · Serious injuriesLimited investigationFinal reportMorrisey 2150A · Winston Salem, NCA blocked fuel vent line, which prevented normal fuel flow to the engine and subsequent loss of power.Dec 29, 1989 · N5145V · Substantial damage NTSB ATL89LA111Accident · 1 fatalLimited investigationFinal reportMorrisey 2150A · Lenoir, NCPilot disregarded the apparent severity of the approaching thunderstorms and attempted a circuit of the airport under visual flight rules when it was not possible. The pilot's lack of recent flight experience was a contributing factor.Mar 18, 1989 · N41HB · Destroyed NTSB LAX87FA096Accident · 2 fatalField investigationFinal reportMorrisey 2150A · Mt. Baldy, CADuring a local flt, the airplane was seen circling over a ridge four times. On the fifth pass, the airplane disappeared northbound into the clouds. A witness reported that at the time the mt tops were covered with fog and that blizzard conditions existed.…Jan 16, 1987 · N5138V · Destroyed NTSB NYC81FHD36Accident · Serious injuriesClosedMorrisey 2150A · Port Republic, NJAug 28, 1981 · N5133V · Substantial damage NTSB NYC78FHM02Accident · No injuriesClosedMorrisey 2150A · Kent, NYDec 30, 1977 · N5139V · Destroyed NTSB IAD76FLQ16Accident · No injuriesClosedMorrisey 2150A · Carrboro, NCNov 3, 1975 · N917JL · Substantial damage NTSB LAX70DUJ35Accident · No injuriesClosedMorrissey 2150A · Phoenix, AZMay 21, 1970 · N5128V · Substantial damage NTSB LAX69A0063Accident · 2 fatalClosedMorrisey 2150A · Peoria, AZMay 9, 1969 · N5141V · Destroyed NTSB CHI69A0001Accident · 1 fatalClosedMorrisey 2150A · Lawrenceville, ILJul 2, 1968 · N5136V · Destroyed NTSB DIA67D0008Accident · No injuriesClosedMorrisey 2150A · New Castle, VAOct 29, 1966 · N5142V · Substantial damage NTSB DEN66A0072Accident · 2 fatalClosedMorrisey 2150A · Parker, AZApr 3, 1966 · N5143V · Destroyed NTSB CHI66D0048Accident · No injuriesClosedShinn 2150A · Wellington, OHJun 18, 1965 · N5124V · Substantial damage NTSB MIA65F0111Accident · No injuriesClosedMorrisey 2150A · Gainesville, GAMay 19, 1965 · N5132V · Substantial damage NTSB MIA65F0055Accident · Serious injuriesClosedMorrisey 2150A · Gainesville, GAFeb 28, 1965 · N5146V · Destroyed NTSB SEA65F0002Accident · No injuriesClosedShinn 2150A · Othello, WAFeb 6, 1965 · N5122V · Substantial damage

Back to Morrisey 2150A