NTSB investigations, OK
11 cases where the first occurrence was “Midair collision”.
Cases per year
| 1984 | 1 |
|---|---|
| 1985 | 1 |
| 1986 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1996 | 1 |
| 2000 | 2 |
| 2001 | 1 |
| 2005 | 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.\"eventStateOrRegion\" = 'OK' AND c.\"eventCountry\" = 'USA'
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\" = 270)
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."eventStateOrRegion" = 'OK' AND c."eventCountry" = 'USA' 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" = 270) 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 CHI05FA055Accident · 1 fatalField investigationFinal reportCessna T-37B · Hollister, OKThe pilots of the AT-502B and the T-37B failed to maintain adequate visual lookout and did not maintain clearance from the other aircraft. Contributing factors included the lack of a transponder and radios on the AT-502B, and the reduced visibility due to…NTSB FTW01FA058Accident · 2 fatalField investigationFinal reportCessna 152 · Platter, OKthe failure of both pilots to maintain a visual lookout, which resulted in a mid-air collision over a lake. A contributing factor to the accident was the sun glare from the setting sun.NTSB FTW00FA154Accident · 2 fatalField investigationFinal reportCessna 152 · Noble, OKthe failure of both pilots to maintain visual lookout.NTSB FTW00FA083Accident · 1 fatalField investigationFinal reportCessna 182M · Mcalester, OKThe failure of both pilots to maintain visual lookout while maneuvering in the traffic pattern.NTSB FTW96FA234Accident · 4 fatalField investigationFinal reportFairchild KR-31 · Bartlesville, OKThe failure of each pilot-in-command to maintain visual lookout. Factors were: the lack of each pilot-in-command obtaining/maintaining communication with the control tower, and inadequate lookout by each pilot-rated passenger, the inadequate…NTSB FTW93IA141Incident · No injuriesIncident investigationFinal reportCommander 114B · Oklahoma City, OKThe pilot of the pitts, N51ST, misunderstanding of the tower's instructions and clearance, and his failure to see and avoid the Commander 114B, N194A.NTSB FTW91FA074Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-20 · Kenefic, OKImproper planning/decision by the pilots of both aircraft, and the Mitsubishi pilot's misjudgment of his position, while attempting to fly formation at night with an aircraft that did not have all navigation lights operative. Factors related to the accident…NTSB FTW89IA168Incident · No injuriesIncident investigationFinal reportCessna 152 · Bethany, OKFailure of the Cessna 150 pilot to see-and-avoid the Cessna 152 (inadequate visual lookout), and failure of the tower controller to provide adequate service. Factors related to the accident were: high traffic density, which resulted in frequency congestion,…NTSB FTW86FA086Accident · 1 fatalField investigationFinal reportCessna 172G · Blackwell, OKThe pilot of N5878R, a Cessna 172G, had no previous experience in formation flying. The pilot of N2603E, an Aeronca 7AC, stated he had many hours of formation flying in the military during world war ii and has made an occasional formation flight since that…NTSB FTW85FA117Accident · 3 fatalField investigationFinal reportPiper PA-32RT-300 · Healdton, OKThe acft collided at 4,500 ft MSL within aprx 15 degrees of head-on. VMC with 30 mi visibility existed with plt reported winds aloft as being light from the west. En route recorded data indicated that N39516 was on a true course of 180 deg and N1162N was on a…NTSB FTW84LA155Accident · No injuriesLimited investigationFinal reportCessna 152 · Durant, OKBefore takeoff, a student & a commercial plt agreed to rendezvous & fly formation while the student took pictures of the commercial plt's acft. The student was to fly a Cessna 152, N4861B, while the commercial plt flew a Cessna 150, N704V6. They planned for…