NTSB investigations, MD
23 cases where the first occurrence was “In flight encounter with weather”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 3 |
| 1993 | 1 |
| 1995 | 2 |
| 1996 | 1 |
| 1997 | 2 |
| 1998 | 1 |
| 2001 | 1 |
| 2002 | 2 |
| 2007 | 2 |
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\" = 'MD' 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\" = 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" = 'MD' 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" = 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 NYC07LA105Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · La Plata, MDAn in-flight encounter with turbulence and the flight crew's failure to advise the cabin crew about potential forecast turbulence, as reported by the flight attendant.NTSB NYC07FA091Accident · 3 fatalField investigationFinal reportPiper PA-30 · Trappe, MDThe pilot's improper decision to fly into an area of thunderstorms, which resulted in a loss of aircraft control and subsequent in-flight breakup. Contributing to the accident was the thunderstorm.NTSB NYC03FA015Accident · 1 fatalField investigationFinal reportCessna 182S · Accident, MDThe pilots improper in-flight decision to continue flight into known adverse weather conditions. A factor related to the accident was the icing conditions.NTSB IAD02FA075Accident · 1 fatalField investigationFinal reportBeech S-35 · Clear Spring, MDThe pilot's continued visual flight into instrument meteorological conditions, which resulted in an in-flight collision with rising terrain. Factors included dense fog and mountainous terrain.NTSB IAD01FA096Accident · 3 fatalField investigationFinal reportPiper PA-28RT-201 · Rohrersville, MDThe pilot's continued VFR flight into obscured, mountanous terrain. Factors included the rising terrain and weather obscuration.NTSB IAD99FA005Accident · 1 fatalField investigationFinal reportCessna R172K · Bowie, MDThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Also causal was the pilot's poor in-flight planning/decision, and his continued VFR flight into instrument meteorological conditions. A related factor was the fog.NTSB NYC98FA041Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Pittsville, MDthe pilot's impairment of judgment and performance due to alcohol, his resultant improper planning/decision and flight in instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude while flying over wooded terrain. Factors…NTSB IAD97FA038Accident · 1 fatalField investigationFinal reportCessna 150F · Bittinger, MDVFR flight by the noninstrumented-rated pilot into instrument meteorological conditions (IMC), which lead to spatial disorientation of the pilot, his loss of aircraft control, and an uncontrolled collision with the terrain. Factors relating to the accident…NTSB IAD96LA083Accident · No injuriesLimited investigationFinal reportLithuanian Factory of LAK-12 · Woodbine, MDThe pilot's decision to fly with inadequate research of forecast weather.NTSB BFO95LA098Accident · No injuriesLimited investigationFinal reportCessna 182 · Annapolis, MDThe pilot's failure to maintain control of the airplane during the landing roll. Related factors were the sudden thunderstorm, the high gusty winds, and the sudden windshift to a tailwind during the touchdown/landing roll.NTSB BFO95FA071Accident · 1 fatalField investigationFinal reportCessna 182P · Frederick, MDthe pilot's continued flight into known adverse weather during descent, which resulted in in-flight collision with terrain. Related factors were the pilot's disregard of a hazardous weather advisory, and the low ceilings, fog and drizzle.NTSB BFO93FA093Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201 · Hancock, MDImproper planning/decision by the pilot, his initiation of VFR flt into instrument meteorological conditions (IMC), and his loss of aircraft control due to spatial disorientation. Factors related to the accident were fog, rain, the pilot's self induced…NTSB BFO89FA069Accident · 3 fatalField investigationFinal reportBeech B50 · Church Creek, MDVFR flight into IMC and pilot disorientation, which resulted in the loss of aircraft control. Contributing to the accident was the pilot's lack of instrument experience, darkness, and the adverse weather condition.NTSB BFO89FA058Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Libertytown, MDContinued VFR flight by the non-instrument rated pilot into instrument meteorological conditions (IMC), which resulted in the pilot's loss of aircraft control due to disorientation, and overload failure of the wings and stabilator due to the pilot exceeding…NTSB BFO89FA043Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Myersville, MDContinued flight by the pilot into instrument meteorological conditions (IMC) and his inability to maintain control of the aircraft after becoming spatially disoriented. Contributing factors were hilly/mountainous terrain, weather conditions, the pilot's lack…NTSB BFO88LA061Accident · Serious injuriesLimited investigationFinal reportBoeing 737 · Salisbury, MDBefore the flt, the crew received a severe wx warning concerning wx along the route of flt. The captain informed the flight attendants to be prepared to have passenger service completed early and to be seated before the descent. Before encountering…NTSB BFO87FA022Accident · 2 fatalField investigationFinal reportRobinson R22 · Myersville, MDThe non-instrument rated commercial pilot departed hgr in a Robinson helicopter that was not equipped to fly in instrument conditions. The pilot had not logged any instrument time and elected to depart in IFR conditions under a special VFR clearance. ATC…NTSB BFO86FA042Accident · 3 fatalField investigationFinal reportPiper PA-30 · Bowleys Qrtrs, MDDrg arr, TRACON gave the plt the arpt wx & provided vectors for an ILS rwy 32 apch. The plt inquired about a cell that he understood was over the arpt & was advised to standby while the controller (ctlr) checked on it. The ctlr contacted twr psnl who adzd the…NTSB BFO85LA054Accident · No injuriesLimited investigationFinal reportCessna 172-RG · Thurmont, MDUpon encountering a low ceiling, precipitation, and haze at approximately 1500 feet MSL, the plt descended in order to locate a suitable landing area. The plt observed a grass airstrip below him, and executed a hard landing. The aircraft bounced once, and…NTSB ATL83FA328Accident · Serious injuriesField investigationFinal reportBoeing 707-323C · Baltimore, MDThe flt encountered turbulence about 20-25 min prior to landing. The flt attendants were retrieving cups & trash at the conclusion of a hot meal service. An attendant was thrown upward striking the ceiling, then fell to the floor causing a lower back injury.…NTSB ATL82FA086Accident · 3 fatalField investigationFinal reportMooney M20F · Mchenry, MDAt 0635 the plt received a wx briefing which included forecasted icing conditions along his route of flt. At 1215 received an updated briefing & was informed that IMC existed along his route of flt & VFR flt was not recommended. At 1536 he called & received…NTSB ATL82FA072Accident · 1 fatalField investigationFinal reportCessna 150 · Tilghman Island, MDThe student pilot/owner of the aircraft was endorsed to fly the plane and would fly it from his farm on Tilghman Island to easton, MD for dual instruction. Several days before the accident, he had asked his instructor (ip) to schedule some time for an early…NTSB ATL82DA031Accident · No injuriesFinal reportBeech V35 · Westminister, MDThe pilot reported encountering severe downdrafts and turbulence at the runway threshold. He stated that he applied full throttle, but the aircraft touched down prematurely and was angled about 30 degrees right of the runway heading. The aircraft came to rest…