Final NTSB investigations, ND

75 cases where NTSB found Task performance.

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\" = 'ND' AND c.\"eventCountry\" = 'USA'
    AND c.\"completionStatus\" = 'Completed'
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0206'))
  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 CEN12LA336Accident · 1 fatalLimited investigationFinal reportBellanca 8GCBC · Zahl, NDThe non-certificated pilot's improper preflight planning, which resulted in fuel exhaustion, and his failure to maintain airplane control after a total loss of engine power.Jun 4, 2012 · N88095 · Substantial damageNTSB CEN12CA042Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · West Fargo, NDThe pilot's excessive use of brakes during the landing roll before the tailwheel had made sustained contact with the runway.Oct 24, 2011 · N7949 · Substantial damageNTSB CEN11LA593Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-400 · Monango, NDThe pilot did not maintain adequate separation from a tree during the aerial-application flight.Aug 23, 2011 · N23720 · Substantial damageNTSB CEN11CA570Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Minot, NDThe pilot's failure to maintain directional control during the crosswind landing, resulting in a ground loop.Aug 3, 2011 · N8764S · Substantial damageNTSB CEN11FA508Accident · 1 fatalField investigationFinal reportBeech A36 · Williston, NDThe pilot's improper fuel management, which resulted in fuel starvation and a partial loss of engine power while maneuvering at a low altitude.Jul 26, 2011 · N41MK · Substantial damageNTSB CEN11CA521Accident · No injuriesData collectionFinal reportMills GS-2 · Jamestown, NDThe pilot's loss of directional control during landing in gusty crosswind conditions.Jul 20, 2011 · N343A · Substantial damageNTSB CEN11CA477Accident · No injuriesData collectionFinal reportPiper PA-25-235 · Minot, NDThe pilot's inadequate inspection of the takeoff area which resulted in a collision with terrain and the subsequent loss of control during takeoff.Jul 14, 2011 · N7709Z · Substantial damageNTSB CEN11LA397Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Grand Forks, NDThe student pilot's inadequate recovery from an autorotation and the CFI's delayed remedial action.Jun 15, 2011 · N2077E · Substantial damageNTSB CEN11LA386Accident · No injuriesLimited investigationFinal reportCessna 172S · Grand Forks, NDThe flight instructor’s delayed remedial action to the student pilot’s bounced landing and subsequent loss of aircraft control.Jun 13, 2011 · N539ND · Substantial damageNTSB CEN11CA306Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Crosby, NDThe pilot’s failure to maintain directional control of the airplane during the crosswind landing.Apr 23, 2011 · N3854P · Substantial damageNTSB CEN11CA056Accident · Minor injuriesData collectionFinal reportCessna 150H · Kenmare, NDThe pilot's inadequate landing flare and recovery from a bounced landing.Nov 4, 2010 · N23099 · Substantial damageNTSB CEN10CA412Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Edmore, NDThe pilot's selection of unsuitable terrain for landing.Jul 17, 2010 · N8774S · Substantial damageNTSB CEN10CA333Accident · No injuriesData collectionFinal reportWsk-Pzl Warzawa-Okecie PZL-104 Wilga 80 · Linton, NDThe pilot's failure to maintain aircraft control during landing with a 90-degree crosswind.May 15, 2010 · N4346M · Substantial damageNTSB CEN10CA191Accident · No injuriesData collectionFinal reportMaule M-5-210C · Bismarck, NDThe pilot’s failure compensate for the crosswinds resulting in a loss of directional control while landing.Apr 5, 2010 · N62040 · Substantial damageNTSB CEN10CA026Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Grand Forks, NDThe flight instructor's failure to ensure the landing gear was extended prior to landing.Oct 22, 2009 · N593ND · Substantial damageNTSB CEN10CA025Accident · No injuriesData collectionFinal reportCessna 172S · Grand Forks, NDThe student pilot's improper landing flare and recovery from a bounced landing.Oct 20, 2009 · N519ND · Substantial damageNTSB CEN09LA565Accident · Serious injuriesLimited investigationFinal reportBell UH-1B · Arvilla, NDThe aircraft owner/mechanic/pilot's installation of an improper tail boom assembly and the resulting fatigue failure of the tail boom's attach fittings.Sep 6, 2009 · N204JB · Substantial damageNTSB CEN09CA404Accident · No injuriesData collectionFinal reportCessna 172S · Grand Forks, NDThe student pilot's improper landing flare that resulted in a hard landing.Jul 2, 2009 · N538ND · Substantial damageNTSB CEN09CA402Accident · No injuriesData collectionFinal reportCessna 172S · Grand Forks, NDThe student pilot's improper landing flare and recovery from a bounced landing.Jul 2, 2009 · N525ND · Substantial damageNTSB CEN09LA277Accident · 2 fatalLimited investigationFinal reportChampion 7GCBC · Surrey, NDThe pilot’s failure to maintain control of the airplane during an abrupt pull-up maneuver, which resulted in an aerodynammic stall at low altitude.May 3, 2009 · N5106T · DestroyedNTSB CEN09LA231Accident · No injuriesLimited investigationFinal reportCessna R172K · Hazen, NDThe pilot's failure to maintain directional control of the airplane during the landing roll.Mar 29, 2009 · N736CL · Substantial damageNTSB CEN09CA219Accident · No injuriesData collectionFinal reportAeronca 7AC-CONV · Stanley, NDThe pilot's failure to maintain directional control during landing.Mar 15, 2009 · N82041 · Substantial damageNTSB CEN09CA156Accident · No injuriesData collectionFinal reportRockwell International 500-S · Grand Forks, NDThe pilot's failure to extend the landing gear prior to touchdown.Dec 5, 2008 · N51RF · Substantial damageNTSB CHI08CA157Accident · Minor injuriesData collectionFinal reportCessna 172C · Nortonville, NDThe pilot's inadequate preflight which resulted in insufficient fuel on board to complete the flight. A factor associated with the accident was the soft terrain encountered during the forced landing.Jun 4, 2008 · N1437Y · Substantial damageNTSB CHI08CA131Accident · Minor injuriesData collectionFinal reportKuntz Kuntz 2000 GTS EFI · Dickinson, NDThe pilot's inadequate preflight weather evaluation and the unsuitable terrain encountered during the precautionary landing at night. Contributing to the accident was the pilot becoming lost after inadvertently encountering fog while en route, the night…May 10, 2008 · N610RD · Substantial damage