Skip to content

NTSB investigations · 21

Matched to the registry by N-number and event date, newest first.

Query with SQL

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.aircraft_model_code IN ('3021433') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.aircraft_model_code IN ('3021433')
  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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('3021433')
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 MIA01IA110Incident · No injuriesIncident investigationFinal reportDouglas DC3A · San Juan, PRThe captain's activation of the left propeller feathering button after failure of the right engine for undetermined reasons resulting in loss of all engine power and the airplane making a forced landing in water.Apr 4, 2001 · N19BA · Minor damage NTSB FTW96FA262Accident · Minor injuriesField investigationFinal reportDouglas DC3A · Cut And Shoot, TXThe flight instructor's failure to use the single engine best angle of climb airspeed resulting in a loss of control of the aircraft. Factors were the loss of power to the left engine for undetermined reasons, the flight instructor not being qualified to be…Jun 20, 1996 · N23WT · Destroyed NTSB FTW87LA180Accident · No injuriesLimited investigationFinal reportDouglas DC-3A · Laredo, TXThe left engine failed during initial climb immediately after liftoff. Airspeed could not be maintained with one engine out due to the fact that the aircraft was climbing slowly just above the surface and was loaded to 3,809 pounds above its maximum allowable…Jul 29, 1987 · N39DT · Substantial damage NTSB MIA87IA195Incident · No injuriesIncident investigationFinal reportDouglas DC3A · Hilliard, FLAccording to the FAA the pilot stated that just after he rotated for takeoff the acft lost power in the left eng. He then aborted the takeoff, set the acft back on the runway & it slid off the left side into some bushes. The plts did not submit an operator…Jun 30, 1987 · N31MS · Minor damage NTSB CHI82FEE14Accident · No injuriesFinal reportDouglas DC-3A · Sandwich, ILAfter returning from a parachute jumping flight, the pilot elected to land on the 1800 ft grass runway. A 3000 ft asphalt runway was available, but he had been using the grass runway to avoid wear on the tires. There was a 30 ft powerline at the approach end…May 29, 1982 · N129H · Substantial damage NTSB MIA82FA037Accident · Minor injuriesField investigationFinal reportDouglas DC-3 · 15nm W. Opa Loc, FLDuring a touch & go the dual student added power rapidly & the left eng sputtered causing the acft to swerve left. The instructor took control but felt resistance on the controls from the student. He then reduced power on both engs & then reapplied power at…Jan 21, 1982 · N211TA · Destroyed NTSB MIA77DLD39Accident · No injuriesClosedDouglas DC-3 · Polk City, FLMar 18, 1977 · N25670 · Substantial damage NTSB FTW76AF056Accident · No injuriesClosedDouglas DC-3A · Corpus Christi, TXJan 4, 1976 · N80BA · Substantial damage NTSB CHI74AC045Accident · No injuriesClosedDouglas DC3A · Ypsilanti, MIDec 2, 1973 · N8661 · Substantial damage NTSB MIA72AM038Accident · No injuriesClosedDouglas DC-3 · St Maarten (Atlantic Ocean)Oct 2, 1971 · N1981W · Destroyed NTSB FTW71IF082Incident · No injuriesClosedDouglas DC-3A · Okla.City, OKJun 11, 1971 · N692A · Minor damage NTSB FTW70A0002Accident · No injuriesClosedDouglas DC3A · Austin, TXJul 19, 1969 · N25661 · Substantial damage NTSB CAN70AF541Accident · Minor injuriesClosedDouglas DC-3A · Malcolm Is, CanadaJul 10, 1969 · N139D · Substantial damage NTSB MIA69A0070Accident · No injuriesClosedDouglas DC-3A · Cleveland, TNApr 18, 1969 · N742J · Substantial damage NTSB UNK68X0147Accident · Minor injuriesClosedDouglas DC3A · Tampico, MexicoJun 7, 1968 · N74139 · Destroyed NTSB ANC67I0047Incident · No injuriesClosedDouglas DC-3A · Nome, AKNov 28, 1966 · N21748 · Minor damage NTSB FTW66I0118Incident · No injuriesClosedDouglas DC-3 · El Dorado, ARJun 22, 1966 · N28364 · Minor damage NTSB DEN66A0038Accident · 13 fatalClosedDouglas DC-3A · Salt Lake City, UTNov 27, 1965 · N485 · Destroyed NTSB ANC65A0052Accident · No injuriesClosedDouglas DC-3C · Nikolski, AKMay 29, 1965 · N91016 · Substantial damage NTSB UNK64X0567Accident · No injuriesClosedDouglas DC3A · St Louis, MOFeb 15, 1964 · N560R · Substantial damage NTSB UNK64X0158Accident · No injuriesClosedDouglas DC-3A · Miami, FLJan 5, 1964 · N19118 · Substantial damage

Back to Douglas DC3A