NTSB investigations, 1983
14 cases where the first occurrence was “Midair collision”.
Cases per year
| 1982 | 30 |
|---|---|
| 1983 | 14 |
| 1984 | 26 |
| 1985 | 25 |
| 1986 | 29 |
| 1987 | 25 |
| 1988 | 18 |
| 1989 | 19 |
| 1990 | 23 |
| 1991 | 23 |
| 1992 | 12 |
| 1993 | 13 |
| 1994 | 12 |
| 1995 | 15 |
| 1996 | 17 |
| 1997 | 15 |
| 1998 | 15 |
| 1999 | 17 |
| 2000 | 19 |
| 2001 | 7 |
| 2002 | 10 |
| 2003 | 11 |
| 2004 | 12 |
| 2005 | 11 |
| 2006 | 8 |
| 2007 | 9 |
Where
Latest 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 year(c.\"eventDate\") = 1983
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 year(c."eventDate") = 1983 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 NYC84FA038Accident · 4 fatalField investigationFinal reportCessna 172P · Silver Greek, NYThe two acft were involved in a midair collision near Silver creek, NY. The plt of N4089P was flying in the left seat & using an instrument hood with a safety plt in the right seat. The plt of the other acft was on a pleasure flt with his daughter. Both acft…NTSB LAX84LA077Accident · Serious injuriesLimited investigationFinal reportCessna TU206F · Riverside, CAThe plt of a Cessna TU206F, N7320Z, stated that he advised other traffic of his position & intentions on the UNICOM freq as he entered a straight-in apch to rwy 24. At about the same time, the plt of a pitts special S-1, N20JK, had returned from a local flt &…NTSB NYC84FA032Accident · 2 fatalField investigationFinal reportBeech K35 · Stockholm, NJAt 1455 EST, a Beech K35 (bonanza), N106Q, & a Piper PA-34-200, N56670, collided while the acft were flying over the vicinity of the sparta VORTAC. The bonanza plt was on a local flt while the PA-34 was on multi-eng training flt. The student in the PA-34…NTSB FTW84FA001Accident · 1 fatalField investigationFinal reportCessna 152 · La Porte, TXCessna 152, N6281Q, & Piper PA-38, N9132A, were both on local, solo student flts. The plt of a 3rd acft, who was holding short for takeoff on rwy 12, observed the Cessna 152 & Piper PA-38 on final apch. Recognizing the potential for a mid-air collision, he…NTSB LAX83FA382Accident · No injuriesField investigationFinal reportStinson 108-3 · Temecula, CAA Stinson 108-3, N12HK, piloted by a private plt, & a Cessna 152, N46757, piloted by a student plt, collided while both acft were ruising at 5500 ft MSL. The private plt (of N12HK) reported he was on a magnetic heading 130 deg & was indicating 92 mph (about…NTSB LAX83FA373Accident · No injuriesField investigationFinal reportCessna 152 · Fullerton, CAN6539L, a Cessna 152, and N1172H a Piper PA-32R-300 collided with each other approx 2 mi west of the Fullerton municipal arpt, at an alt of approx 1200 ft AGL. Both plts rept clear skies, a bright night, and no restrictions to vis. Both plts stated they made…NTSB NYC83FA188Accident · 4 fatalField investigationFinal reportCessna U206G · Brooklyn, NYA Cessna U206G float plane, N5328X, & a bell 206A police helicopter, N4797R, collided in flt over Brooklyn, NY. The aircrew of the police helicopter were on a traffic observation flt & had just reported traffic conditions in the vicinity of a toll station…NTSB MIA83FU005Accident · Serious injuriesFinal reportPterodactyl Ascender · Jacksonville, FLThe plts of 2 high wing, pterodactle ascender, ultralight vehicles took off & were operating in a designated area for ultralights. One plt (plt-a) was making touch & go landings while the other plt (plt-b) was maneuvering in the vicinity. After plt-a made a…NTSB ATL83FA224Accident · Serious injuriesField investigationFinal reportCessna 172 · Mocksville, NCN5722T, a Cessna 172, and N3452J, a Cessna 150, collided over the approach end of runway 09 while both acft were on short final approach. Both acft impacted the runway and came to rest about 280 ft east of runway 09 threshold.NTSB LAX83FA242Accident · 1 fatalField investigationFinal reportSchempp-Hirth Standard Cirrus · Bridgeport, CATwo Schempp-Hirth gliders, N184N & N6482, were being flown in a x-country contest along a triangular course. The course started at minden, NV & went to schurz, NV & Bridgeport, CA, then back to minden. The plts of both gliders had participated in contests for…NTSB NYC83FU005Accident · 1 fatalFinal reportRobertson B1-RD · Enfield, NYDuring flt, the 2 ultralight vehicles were observed flying in close proximity to each other. Later, they were observed approaching the departure field at aprx 300 to 500 ft AGL. The lead vehicle, sn:115, with a non-rated plt, began a left turn. The other…NTSB DEN83AA105Accident · 3 fatalFinal reportCessna 340 · Rock Springs, WYThe aircrew of a Cessna 340, N5415M, were scheduled for an air taxi check ride with an inspector at jackson, WY, later in the afternoon. They had planned to takeoff from Rock Springs, WY, practice a few instrucment apchs at Rock Springs, then proceed to…NTSB ANC83LA049Accident · No injuriesLimited investigationFinal reportRaven RX-7 · Anchorage, AKThe two balloons collided in mid air. One (N4195L) suffered a rip in the envelope which negated its lift, with burner full on. It descended at 500 RPM and made a hard landing. The hole in the envelope extended across 5 gore panels. The 2 balloons departed the…NTSB ATL83MA084Accident · 7 fatalClass 1 · MajorFinal reportBeech D55 · Cherry Point, NCThe two acft collided at about 9,500 ft MSL 30 mi south of Cherry Point. After departing nassau, the plt of the BE-D55 never activated his flt plan. An adiz penetration time was therefore never established. When the unidentified acft entered warning area…