NTSB investigations, MA

718 cases where the phase of flight was Landing.

Cases, newest first

Query with SQL
duckdb -csv -c "WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
    crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
    current_codes AS (
      SELECT e.case_mkey, TRY_CAST(e.\"tier1Number\" AS INTEGER) AS code,
        row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e.\"isDefiningEvent\", false) DESC, e.position) AS n
      FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
      WHERE e.aircrafts_position = 1 AND e.\"tier1Number\" GLOB '[1-9][0-9]*'
        AND (e.\"isDefiningEvent\" OR e.case_mkey IN (SELECT \"mKey\" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE \"isPre1982\"))
    ),
    phases AS (
      SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
      FROM current_codes WHERE n = 1
      UNION ALL
      SELECT o.case_mkey, 'older', o.\"phaseOfFlightCode\", w.main
      FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o.\"phaseOfFlightCode\"
      WHERE o.aircrafts_position = 1 AND o.\"occurrenceNumber\" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
    ),
    case_phases AS (
      SELECT p.*, c.\"eventDate\", c.\"highestInjuryLevel\" = 'Fatal' AS fatal, a.aircraft_model_code
      FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = p.case_mkey
      LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
      WHERE c.\"eventDate\" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
    )
  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\" = 'MA' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 550)
  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.

NTSB ERA11LA379Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Egremont, MAA partial loss of engine power due to the No. 4 intake and exhaust valves becoming lodged in the valve guides, which resulted from a lack of use, improper engine storage preparation, and improper return to service from indefinite storage.Jul 5, 2011 · N98550 · Substantial damageNTSB ERA11CA350Accident · No injuriesData collectionFinal reportEiriavion PIK 20B · Sterling, MAThe pilot's misjudgment of the amount of flaps required to attain the proper touchdown point. Contributing to the accident was the pilot's limited experience in the high performance glider.Jun 16, 2011 · N99136 · Substantial damageNTSB ERA11CA262Accident · No injuriesData collectionFinal reportCessna U206G · Stow, MAThe pilot's inadequate compensation for the crosswind condition and his failure to maintain directional control during landing.Apr 24, 2011 · N304EB · Substantial damageNTSB ERA11CA199Accident · No injuriesData collectionFinal reportLuscombe 8E · Taunton, MAThe pilot's inadvertent application of the brakes during recovery from a ground loop which resulted in a nose over.Mar 19, 2011 · N2790K · Substantial damageNTSB ERA10CA513Accident · No injuriesData collectionFinal reportPiper PA34 · Northampton, MAThe pilot's improper recovery from a bounced landing.Sep 23, 2010 · N56196 · Substantial damageNTSB ERA10CA496Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Marlboro, MAThe pilot’s improper touchdown point and failure to perform a go-around in a timely manner, which resulted in a runway excursion.Sep 22, 2010 · N260ND · Substantial damageNTSB ERA10IA378Incident · No injuriesIncident investigationFinal reportCessna 402C · Hyannis, MAThe pilot's failure to extend the landing gear prior to landing flare and touchdown.Jul 26, 2010 · N26150 · Minor damageNTSB ERA10LA216Accident · No injuriesLimited investigationFinal reportSmith Richard D JR Revolution Mini 500 · Middleboro, MAA loss of engine coolant, which resulted in a loss of engine power during the pilot’s attempt to cushion a precautionary landing. Contributing to the accident was a disconnected engine coolant hose and the pilot's inadequate preflight inspection.Apr 7, 2010 · N118NR · Substantial damageNTSB ERA10CA169Accident · No injuriesData collectionFinal reportCessna 150H · New Bedford, MAThe pilot’s failure to maintain directional control during a crosswind landing/rollout.Mar 7, 2010 · N6603S · Substantial damageNTSB ERA10CA124Accident · No injuriesData collectionFinal reportCessna 150 · Taunton, MAThe pilot's failure to obtain the proper touchdown point during landing.Jan 26, 2010 · N5478Q · Substantial damageNTSB ERA10CA122Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Great Barrington, MAThe pilot's improper approach, failure to perform a go-around, and failure to maintain directional control while braking after a long landing.Jan 21, 2010 · N8428H · Substantial damageNTSB ERA09LA538Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2B16 · Vineyard Haven, MAThe pilot's improper flare while landing in gusting wind, which resulted in a hard landing.Sep 27, 2009 · N190MP · Substantial damageNTSB ERA09CA489Accident · No injuriesData collectionFinal reportPiper J5A · Holland, MAA loss of engine power due to fuel exhaustion. A factor in the accident was the pilot's inadequate preflight inspection.Aug 27, 2009 · N33078 · Substantial damageNTSB ERA09CA553Accident · No injuriesData collectionFinal reportChampion 7GCAA · Ware, MAThe pilot's failure to maintain control of the airplane during landing.Jun 27, 2009 · N1879G · Substantial damageNTSB ERA09LA295Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 40 · Norwood, MAThe student pilot's failure to maintain directional control during the landing rollout, which resulted in excessive side loads to the right main landing gear and the separation of the outer main landing gear rib from the right wing.May 16, 2009 · N323JT · Substantial damageNTSB ERA09CA277Accident · No injuriesData collectionFinal reportPiper PA-30 · Great Barrington, MAThe pilot's improper decision to land with a tailwind.Apr 30, 2009 · N8034Y · Substantial damageNTSB ERA09IA267Incident · No injuriesIncident investigationFinal reportCessna 402C · Nantucket, MAInstallation of an improper bearing in the landing gear actuator.Apr 27, 2009 · N769EA · Minor damageNTSB ERA09CA063Accident · No injuriesData collectionFinal reportCessna 172 · Bedford, MAThe student pilot's inadequate compensation for winds during landing.Nov 17, 2008 · N2439Z · Substantial damageNTSB NYC08CA327Accident · No injuriesData collectionFinal reportPiper PA 28-161 · Beverly, MAAn inadvertent collision with a deer while landing.Sep 28, 2008 · N8369A · Substantial damageNTSB NYC08CA274Accident · No injuriesData collectionFinal reportBoeing E75 · Sterling, MAThe owner/pilot's improper flare. Contributing to the accident was the pilot-in-command's inadequate remedial action.Aug 8, 2008 · N4923N · Substantial damageNTSB LAX08CA172Accident · No injuriesData collectionFinal reportCessna T337G · GreatBarrington, MAThe pilot's misjudgment of distance and altitude, and failure to attain the proper touchdown point. The pilot's delayed remedial action was also causal.Jun 8, 2008 · N337JJ · Substantial damageNTSB MIA08CA107Accident · No injuriesData collectionFinal reportWaco GXE · Provincetown, MAThe pilot's failure to maintain directional control while landing.May 25, 2008 · N312DC · Substantial damageNTSB MIA08CA071Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Norwood, MAThe failure of the flightcrew to maintain directional control of the airplane.Mar 2, 2008 · N9182A · Substantial damageNTSB ATL07CA105Accident · No injuriesData collectionFinal reportCessna 172S · Beverly, MAThe pilot's improper flare, which resulted in a hard landing and nose gear collapse. A contributing factor was the wind gust.Jul 15, 2007 · N13151 · Substantial damageNTSB ATL07LA104Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Gardner, MAThe pilot's failure to maintain control of the airplane during an aborted landing.Jul 14, 2007 · N4337P · Substantial damageNTSB NYC07CA074Accident · No injuriesData collectionFinal reportMooney M20R · Marshfield, MAA loss of directional control for undetermined reasons.Mar 9, 2007 · N323RW · DestroyedNTSB NYC07CA093Accident · No injuriesData collectionFinal reportSchweizer 269C · Plymouth, MAThe student pilot's failure to maintain control of the helicopter during landing, and the flight instructor's delayed remedial action.Feb 1, 2007 · N2074K · Substantial damageNTSB NYC07CA046Accident · No injuriesData collectionFinal reportCessna 172R · Northhampton, MAThe pilot's inadequate recovery from a bounced landing.Dec 10, 2006 · N9421Z · Substantial damageNTSB NYC06CA168Accident · No injuriesData collectionFinal reportLiberty Aerospace XL2 · Mansfield, MAThe pilot's improper recovery from a bounced landing.Jul 2, 2006 · N771SF · Substantial damageNTSB NYC06CA152Accident · No injuriesData collectionFinal reportCessna 182F · Beverly, MACollapse of the nose landing gear for an undetermined reason.Jun 17, 2006 · N830W · Substantial damageNTSB NYC06LA124Accident · Minor injuriesLimited investigationFinal reportCessna C-172N · Vineyard Haven, MAThe pilot's improper preflight planning and improper fuel consumption calculations, which resulted in fuel exhaustion and a subsequent loss of engine power.May 28, 2006 · N738HE · Substantial damageNTSB NYC06CA093Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Norwood, MAThe student pilot's failure to maintain directional control during the landing rollout.Apr 11, 2006 · N4359D · Substantial damageNTSB NYC06CA059Accident · No injuriesData collectionFinal reportCessna R182 · Bedford, MAThe pilot's improper flare resulting in a hard landing. A factor in the accident was the wind gusts.Jan 21, 2006 · N6278T · Substantial damageNTSB NYC06CA049Accident · No injuriesData collectionFinal reportPiper PA-34-220T · Lawrence, MAThe pilot's improper flare and recovery from a bounced landing.Jan 2, 2006 · N323RB · Substantial damageNTSB NYC06CA023Accident · No injuriesData collectionFinal reportBeech M35 · Pittsfield, MAThe pilot's inadvertent retraction of the landing gear during the landing roll.Oct 28, 2005 · N120V · Substantial damageNTSB IAD05CA106Accident · No injuriesData collectionFinal reportGrumman American AA-5B · Stow, MAAn inadvertent collision with a deer during the landing roll. A factor was the night lighting conditions.Jul 28, 2005 · N28860 · Substantial damageNTSB IAD05LA111Accident · No injuriesLimited investigationFinal reportCessna 182T · Chatham, MAthe pilot's improper recovery from a bounced landing.Jul 20, 2005 · N1328N · Substantial damageNTSB IAD05LA049Accident · No injuriesLimited investigationFinal reportTaylorcraft F19 · Northampton, MAThe pilot/owner's improper decision to conduct the flight with a known deficiency in equipment, which resulted in a loss of control when the tailwheel springs became disconnected. Factors were the disconnection of the tailwheel springs, the snow bank, and…Mar 19, 2005 · N3679T · Substantial damageNTSB NYC04CA184Accident · No injuriesData collectionFinal reportPascucci RAF 2000 · Beverly, MAThe pilot's failure to maintain aircraft control while landing. A factor in this accident was the crosswind condition.Aug 2, 2004 · N62188 · Substantial damageNTSB NYC04CA134Accident · Serious injuriesData collectionFinal reportCessna 172M · Worcester, MAThe pilot's improper recovery from a bounced landing, and his inadequate compensation for wind conditions. A factor in the accident was the gusting wind.May 29, 2004 · N73704 · Substantial damageNTSB NYC04CA132Accident · Minor injuriesData collectionFinal reportAviat A-1B · Halifax, MAThe pilot's inadequate flare during landing, which resulted in an in-flight collision with water. A factor was the glassy water conditions.May 12, 2004 · N17MR · Substantial damageNTSB NYC04CA114Accident · Minor injuriesData collectionFinal reportCessna 305 A · Taunton, MAThe pilots inadequate pre-flight planning which resulted in a landing on soft terrain and subsequent nose over. A factor was the soft terrain.Apr 30, 2004 · N2070E · Substantial damageNTSB NYC04CA102Accident · No injuriesData collectionFinal reportCessna 172P · Westfield, MAThe student pilot's improper flare and his failure to maintain aircraft control while landing.Apr 9, 2004 · N5425K · Substantial damageNTSB NYC04CA091Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Norwood, MAThe student pilot failure to recover from a bounced landing. A factor in this accident was the student pilot's lack of solo flight experience.Mar 24, 2004 · N6535J · Substantial damageNTSB NYC04CA066Accident · No injuriesData collectionFinal reportPiper PA-23-250 · Grt. Barrington, MAThe pilot's misjudgment of the airplane's distance/speed and failure to obtain the proper touchdown point, which resulted in an overrun. A factor was the cross wind.Feb 9, 2004 · N6760A · Substantial damageNTSB NYC04CA031Accident · No injuriesData collectionFinal reportPiper PA-18 · Westfield, MAThe pilot's failure to maintain aircraft control while landing.Nov 9, 2003 · N3194Z · Substantial damageNTSB NYC04CA018Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Mansfield, MAThe pilot's failure to maintain directional control while landing.Oct 28, 2003 · N33532 · Substantial damageNTSB NYC03MA183Accident · 2 fatalMajor investigationFinal reportBeech 1900D · Yarmouth, MAThe improper replacement of the forward elevator trim cable, and subsequent inadequate functional check of the maintenance performed, which resulted in a reversal of the elevator trim system and a loss of control in-flight. Factors were the flightcrew's…Aug 26, 2003 · N240CJ · DestroyedNTSB NYC03LA166Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Newburyport, MAThe pilot's inadequate compensation for the wind conditions and his inadequate flare.Jul 25, 2003 · N8146Y · Substantial damageNTSB NYC03CA157Accident · Minor injuriesData collectionFinal reportRolladen-Schneider LS-4 · Ashburnham, MAThe pilot's improper in-flight decision to over fly a suitable landing area. Factors in this accident were weak thermal lift activity, and lack of suitable terrain at the time of the landing.Jul 13, 2003 · N130MD · Substantial damage