NTSB investigations

116 cases where NTSB found Aircraft.

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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03022040'))
  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 WPR11CA171Accident · No injuriesData collectionFinal reportRemos GX · Arlington, WAThe LSA pilots' failure to stop and to ensure that the taxiway was clear of conflicting traffic before entering.Mar 19, 2011 · N386GX · 2 aircraft · Substantial damageNTSB WPR11LA017Accident · Serious injuriesLimited investigationFinal reportLindstrand Balloons 90A · Cottonwood, AZThe paraglider pilot's failure to see and avoid the hot air balloon, which resulted in a midair collision.Oct 16, 2010 · N807PW · Substantial damageNTSB WPR10LA189Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Honolulu, HIThe pilot's failure to maintain clearance from a parked airplane during taxi due to his inadequate visual lookout.Apr 4, 2010 · N61384 · Substantial damageNTSB WPR10LA155Accident · No injuriesLimited investigationFinal reportKeller FK1 Stol · Dixie, IDThe failure of the experimental FK1 pilot to maintain clearance from a parked airplane while landing.Feb 26, 2010 · N4XK · 2 aircraft · Substantial damageNTSB CEN09CA600Accident · No injuriesData collectionFinal reportCessna 402B · Omaha, NEThe pilot’s improper decision to taxi with an obstructed windscreen and his failure to maintain clearance from the parked airplane.Sep 22, 2009 · N1048 · Substantial damageNTSB CEN09CA547Accident · No injuriesData collectionFinal reportCessna 182P · Sugar Land, TXThe pilot's failure to control the airplane during engine startup, and his failure to maintain clearance from other objects.Aug 24, 2009 · N1988M · Substantial damageNTSB CEN09CA504Accident · Minor injuriesData collectionFinal reportVanderhoof Steve AIR Comman · Mentone, INThe pilot's failure to maintain aircraft control during the landing and subsequent impact with a parked aircraft.Aug 5, 2009 · N8099P · Substantial damageNTSB CEN09IA222Incident · No injuriesIncident investigationFinal reportBell 206 · Springfield, ILThe pilot's failure to maintain clearance from the parked helicopter.Mar 17, 2009 · N595AE · Minor damageNTSB LAX08CA192Accident · No injuriesData collectionFinal reportCessna 172M · San Diego, CAThe student pilot's failure to maintain directional control during a touch-and-go landing.Jun 24, 2008 · N9629V · Substantial damageNTSB DEN08CA115Accident · No injuriesData collectionFinal reportPiper PA-28-236 · Osage Beach, MOThe pilot failed to maintain separation from the parked airplanes while taxiing at an excessive speed for the conditions. Contributing to the accident was the airport personnel's decision to park the airplanes in close proximity to the taxiway.Jun 22, 2008 · N8106M · Substantial damageNTSB NYC08IA145Incident · No injuriesIncident investigationFinal reportAerospatiale AS355F1 · New York, NYThe pilot's inadequate visual lookout and subsequent failure to maintain clearance from the other helicopter due to his focus on the engine instruments during the initial departure. Contributing to the accident was insufficient helipad spacing.Mar 22, 2008 · N406LH · Minor damageNTSB NYC08CA127Accident · No injuriesData collectionFinal reportCessna 172N · Charlottesville, VAThe pilot's improper engine starting procedures.Mar 8, 2008 · N733LE · Substantial damageNTSB MIA08CA074Accident · No injuriesData collectionFinal reportCessna 525B · Stuart, FLThe flight crew's failure to reset the brakes circuit breaker resulting in a loss of brakes during taxi and an on ground collision with an unoccupied parked airplane.Mar 8, 2008 · N400GG · Substantial damageNTSB DFW08CA071Incident · No injuriesData collectionFinal reportCessna 172S · Austin, TXThe pilot's failure to maintain control of the airplane while parked on the ramp with the engine running.Feb 6, 2008 · N53564 · Minor damageNTSB NYC08CA089Accident · No injuriesData collectionFinal reportCessna 210G · Bessemer, ALThe pilot's failure to properly secure the airplane before attempting to hand-prop the engine.Jan 30, 2008 · N5825F · Substantial damageNTSB SEA08LA061Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2C10 · San Francisco, CAThe company tug operator's failure to maintain clearance with another aircraft during the pushback process. Also causal was the ground controller's failure to alert the pilot of the other aircraft and tug operator of this airplane of the simultaneous pushback…Jan 14, 2008 · N705SK · 2 aircraft · Substantial damage