Fatal NTSB investigations, ME
9 cases where the first occurrence was “In flight encounter with weather”.
Cases per year
| 1983 | 1 |
|---|---|
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 2004 | 1 |
Where
Latest 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\" = 'ME' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 240)
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" = 'ME' AND c."eventCountry" = 'USA' AND c."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240) 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 IAD04LA036Accident · 1 fatalLimited investigationFinal reportCessna 172M · Brownville Junc, METhe pilot's continued visual flight into instrument meteorological conditions, which resulted in the airplane's controlled flight into rising terrain. Factors included the instrument meteorological conditions and the rising terrain.NTSB IAD97FA095Accident · 4 fatalField investigationFinal reportPiper PA-28R-180 · Penobscot, METhe pilot's flight into adverse weather conditions, which resulted in the loss of control. Factors relating to the accident were the fog and the pilot's lack of an instrument rating.NTSB IAD96FA090Accident · 1 fatalField investigationFinal reportCessna 320C · Winslow, MEthe pilot's continued flight into known adverse weather conditions, and his loss of aircraft control, which resulted in an uncontrolled descent into terrain (river). The known icing condition was a related factor.NTSB BFO94FA013Accident · 3 fatalField investigationFinal reportBell 206L-1 · Portland, METhe pilot's continued VFR flight into instrument meteorological conditions, and his failure to assure that adequate fuel was available to complete the flight, resulting in a loss of engine power due to fuel exhaustion. Factors which contributed to the…NTSB NYC92DNC02Accident · 1 fatalFinal reportCraig Morehead Bushby Mustang II · Buxton, METhe failure of the pilot to maintain airspeed while maneuvering which resulted in an inadvertent stall with insufficent altitude for recovery. Factors related to the accident were the low clouds and fog, and the pilot's failure to obtain a weather briefing.NTSB NYC88FA235Accident · 3 fatalField investigationFinal reportCessna 182RG · Greenville, METhe non-instrument rated pilot apparently could not locate the destination airport because of low ceilings and ground fog. Before the pilot started his trip he was advised by the fss that VFR flight to his destination was not recommended. It appears that the…NTSB NYC87FA204Accident · 4 fatalField investigationFinal reportPiper PA-30 · Lincolnville, METhe plt was making an approach to knox county arpt, rockland me and after receiving a wx report from UNICOM that the local wx was below approach minimums he indicated that he would make a missed approach. There was no further communications from the acft. A…NTSB NYC87FA015Accident · 1 fatalField investigationFinal reportCessna 185 · Greenville, METh plt stated that the acft encountered crosswinds of 20 KTS gusting to 30 KTS as the acft was coming off the step during liftoff in the open lake. The acft's right wing was forced down, the right float struck the water which resulted in the right wing…NTSB NYC83FA204Accident · 2 fatalField investigationFinal reportBeech S35 · Wiscasset, METhe acft was observed taking off on a foggy night with a low overcast sky condition. Shortly after taking off, the plane was observed to turn at low alt, then enter a nose down attitude. The acft crashed & the non-instrument rated plt & passenger were fatally…