Major NTSB investigations
7 cases where the first occurrence was “On ground/water collision with object”.
Cases per year
| 1983 | 1 |
|---|---|
| 1986 | 1 |
| 1987 | 1 |
| 1990 | 2 |
| 1991 | 1 |
| 2002 | 1 |
Where
Open the mapLatest cases
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.board_report_url IS NOT NULL OR c.\"investigationClass\" = 'Class 1' OR c.\"caseType\" = 'Major - Launch')
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 310)
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_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.board_report_url IS NOT NULL OR c."investigationClass" = 'Class 1' OR c."caseType" = 'Major - Launch') AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 310) 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 DCA02MA026Accident · No injuriesMajor investigationFinal reportCanadair CL-600-2B19 · Dulles Airport, VAthe airplane's collision with two wild turkeys.NTSB DCA91MA018Accident · 34 fatalClass 1 · MajorFinal reportBoeing 737-300 · Los Angeles, CAThe failure of the Los Angeles air traffic facility management to implement procedures that provided redundancy comparable to the requirements contained in the national operational position standards and the failure of the FAA air traffic service to provide…NTSB DCA91MA010Accident · 8 fatalClass 1 · MajorFinal reportMcdonnell Douglas DC-9-14 · Romulus, MILack of proper crew coordn, including virtual reversal of roles by the DC-9 plts, which led to their failure to stop taxiing & alert gnd ctlr of their positional uncertainty in a timely manner bfr & after intruding onto the active rwy. Contribuing to cause of…NTSB DCA90MA017Accident · 1 fatalClass 1 · MajorFinal reportBeech A100 · Atlanta, GA(1) Failure of the federal aviation administration to provide air traffic control procedures that adequately take into consideration human performance factors such as those which resulted in the failure of the north local controller to detect the developing…NTSB NYC87MA236Accident · No injuriesMajor investigationFinal reportMcdonnell Douglas DC-8-63 · Newburgh, NYThe wx was deteriorating as airborne express flt 124 & rosenbalm flt 074 were on successive arrivals for an ILS rwy 9 apch. Flt 124 was clrd for the apch & lndd. After lndg, the LCL ctlr (l/c) instructed flt 124 to back taxi on the rwy & rprt when clr of the…NTSB DCA87MA010Accident · 1 fatalClass 1 · MajorFinal reportPiper PA-23-150 · Tampa, FLAt aprx 0612 EST, an eastern airline capt (owner of Piper PA-23, N2185P) departed a rwy near his home in VFR conds to commute to work at Tampa, FL. Shortly after takeoff, he contacted a fss & updated the wx info he had obtained on the previous evening. At…NTSB DCA84AA013Accident · Serious injuriesFinal reportMcDonnell Douglas DC-10-30CF · Anchorage, AKA Piper PA-31, N35206, (south central air flt 59) was cleared to taxi to rwy 6L. The wx at that time was foggy with about 1/8 mi vsiibility, but the RVR was improving & the arpt was expected soon to be acceptable for takeoffs. The PA-31 crew taxied & waited…