NTSB investigations, AK

119 cases where the sequence of events included Collision during takeoff/land.

Cases, newest first

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\" = 'AK' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '490' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 ANC09CA080Accident · Serious injuriesData collectionFinal reportCessna 206 · Iliamna, AKThe pilot's decision to takeoff towards an area of rising terrain and potential downdrafts with a fully loaded airplane, which resulted in an encounter with a downdraft that exceeded the airplane's climb capability.Aug 11, 2009 · N5110U · Substantial damageNTSB ANC09CA077Accident · Minor injuriesData collectionFinal reportInfinity Commander · Anchor Point, AKThe pilot's attempt to exceed the climb capability of the powered parachute during takeoff, and his lack of experience.Aug 10, 2009 · N50204 · Substantial damageNTSB ANC09CA076Accident · No injuriesData collectionFinal reportPiper PA-18 · Skwentna, AKThe pilot’s misjudged landing on a downsloping, short landing strip, resulting in a nose over.Aug 2, 2009 · N7509K · Substantial damageNTSB ANC09CA073Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Tok, AKThe pilot's failure to maintain clearance from a parked truck during takeoff from a roadway, resulting in a collision with the truck.Jul 23, 2009 · N39226 · Substantial damageNTSB ANC09LA072Accident · No injuriesLimited investigationFinal reportDehavilland Beaver DHC-2 · Iliamna, AKThe pilot's selection of an unsuitable landing/takeoff area with an unfavorable wind.Jul 22, 2009 · N68088 · Substantial damageNTSB ANC09CA111Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Homer, AKThe pilot's excessive airspeed during approach to compensate for turbulence, resulting in a hard landing and runway overrun.Jul 3, 2009 · N4299Z · Substantial damageNTSB ANC09CA054Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Tyonek, AKThe pilot's selection of unsuitable terrain for landing.Jun 7, 2009 · N82057 · Substantial damageNTSB ANC09CA028Accident · No injuriesData collectionFinal reportPiper PA-12 · Skwentna, AKThe pilot's selection of an unsuitable landing/takeoff area with an unfavorable wind.Apr 4, 2009 · N2997M · Substantial damageNTSB ANC09LA023Accident · No injuriesLimited investigationFinal reportHelio H-295 · Healy, AKThe pilot's delay in initiating a climb while he was packing snow with the airplane's skis in preparation for landing, resulting in a collision with brush.Mar 14, 2009 · N6478V · Substantial damageNTSB ANC09LA022Accident · No injuriesLimited investigationFinal reportDehavilland DHC-2 / U-6A · Kenai, AKThe flight instructor’s decision to attempt a touch-and-go landing toward rising terrain and with a tailwind, resulting in an in-flight collision with terrain during takeoff.Feb 20, 2009 · N5342G · Substantial damageNTSB ANC08LA131Accident · No injuriesLimited investigationFinal reportDehavilland Beaver DHC · Cooper Landing, AKThe pilot's failure to maintain separation from a tree during the landing roll at an off-airport site.Sep 28, 2008 · N203KL · Substantial damageNTSB ANC08CA129Accident · No injuriesData collectionFinal reportEurocopter AS 350 B2 · Kenai, AKThe pilot's failure to maintain tail rotor clearance from the safety netting during final approach and landing.Sep 28, 2008 · N352EV · Substantial damageNTSB ANC08CA128Accident · No injuriesData collectionFinal reportPiper PA-18 · Fairbanks, AKThe pilot's selection of an unsuitable takeoff area. A Factor contributing to the accident was a short, rough and uneven takeoff site.Sep 18, 2008 · N2265A · Substantial damageNTSB ANC08CA125Accident · No injuriesData collectionFinal reportAeronca 15AC · Fairbanks, AKThe pilot's selection of unsuitable terrain for landing, resulting in an on-ground collision with a tree stump.Sep 16, 2008 · N1170H · Substantial damageNTSB ANC08CA123Accident · No injuriesData collectionFinal reportCessna 207 · Dillingham, AKThe pilot's inadequate evaluation of weather and runway conditions, and his improper decision to depart downwind, on a wet gravel runway, resulting in an in-flight collision with terrain after takeoff. Factors contributing to the accident were a tailwind, and…Sep 12, 2008 · N6426H · Substantial damageNTSB ANC08CA116Accident · No injuriesData collectionFinal reportde Havilland DHC-2 · Talkeetna, AKThe pilot's selection of an unsuitable takeoff site, resulting in an on ground collision with tall brush.Aug 30, 2008 · N4081F · Substantial damageNTSB ANC08LA111Accident · Minor injuriesLimited investigationFinal reportCessna 207A · Kongiganak, AKThe pilot's decision to attempt to takeoff on a short, wet runway with a heavily loaded airplane, and his failure to abort the takeoff before it became impracticable.Aug 23, 2008 · N17GN · Substantial damageNTSB ANC08CA110Accident · No injuriesData collectionFinal reportCessna U206G · Igiugig, AKThe pilot's misjudged speed and distance during takeoff, which resulted in the float-equipped airplane colliding with a bank.Aug 20, 2008 · N4773U · Substantial damageNTSB ANC08LA088Accident · No injuriesLimited investigationFinal reportCessna 150 · Manley Hot Spgs, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in a collision with a ditch during the takeoff roll. Factors contributing to the accident were low light conditions at dusk, and soft terrain.Jul 12, 2008 · N22563 · Substantial damage