NTSB investigations, ME
11 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
Cases per year
| 1984 | 2 |
|---|---|
| 1988 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1997 | 1 |
| 2002 | 1 |
| 2005 | 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\" = 'ME' AND c.\"eventCountry\" = 'USA'
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\" = 130)
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."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130) 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 NYC05IA128Incident · No injuriesIncident investigationFinal reportBeech 1900D · Rockland, MEA loose elevator attachment, which resulted in a partial elevator binding during takeoff and uncommanded elevator movement during cruise.NTSB NYC02LA120Accident · Serious injuriesLimited investigationFinal reportSmith Kitfox Classic IV · Limerick, METhe pilot's failure to perform a modification required by the manufacturer, which resulted in a failure of the float covering.NTSB NYC97FA045Accident · Minor injuriesField investigationFinal reportBeech 1900D · Bangor, METhe inadequate flight and winter operations training provided by the operator, and the pilot's improper decision to abort the takeoff while airborne above V1, due to a false stall warning horn. Also casual was the airport operations improper decision to…NTSB BFO94LA159Accident · No injuriesLimited investigationFinal reportBell UH-1B · Carrabasset, MEFracture failure of the tail rotor drive intermediate gearbox.NTSB NYC94LA032Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · North Haven, METhe pilot's use of excessive speed and altitude during the approach which resulted in a landing overrun of the runway. Factors were a precautionary landing and a ravine.NTSB BFO92FA093Accident · 1 fatalField investigationFinal reportCessna U206F · Portland, MEImproper in-flight planning/decision by the pilot, resulting in fuel starvation due to improper positioning of the fuel selector. Factors related to the accident were: an undetermined electrical failure, and loss of fuel quantity indication.NTSB NYC92LA036Accident · No injuriesLimited investigationFinal reportPiper PA-31-T1040 · Portland, METhe excessive fuel pressure during inflight fuel transferring, which resulted in the rupture of the wing tank and subsequent damage to the wing. Also causal to the accident was the inadequate fuel tank vent system and the inaccurate fuel quantity system.NTSB NYC91DNC01Accident · 2 fatalFinal reportSkytek Skyseeker MK II · Chapman, MEIn-flight failure of the outboard section of the wing, and the loss of aircraft control. Due to the unauthorized structural modification by the pilot/owner.NTSB NYC88FA167Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Livermore Falls, METhe citabria 7GCBC was observed to make a loop. The left wing bent upward at the strut attach point as the aircraft was at the bottom of the loop and recovering to level flight. The aircraft was then observed to descend in a right spiral and not recover prior…NTSB NYC84LA278Accident · No injuriesLimited investigationFinal reportCessna C182 · Norridgewock, MEA parachte became entangled in the horizontal stabilizer while the acft was maneuvering to drop the parachutists. The acft made a hard landing after the parachustist disengaged from the acft. The acft stabilizer spar was damaged in the encounter and the lack…NTSB NYC84IA225Incident · Minor injuriesIncident investigationFinal reportBoeing 737-130 · Portland, MECaptain heard loud 'pop' and observed an electrical panel interruption along with illumination of rt 'bus off' & 'gen off bus' lights. No generator amps or freqs were observed. Faint odor of smoke. Capt started APU and put APU generator on rt side. 'Bus off'…